Ab-normalization at Experts Exchange - part 8

The question today:
Trying to use CASE statement in ADO execute command

It almost gets boring as this is another "classic" example of redundant data trouble.
Why have a table field filled with the same value as another field when empty?

The first question I would ask before advising such a questioner is why a field is occurring twice in the table. The tell tale field name "Salesperson2" indicates normalization hasn't been applied.

But, you're having a bad day when you're advised by the #1 MS Access expert at Experts-Exchange. This "expert" will give you as solution the code to update the field in the table and won't mention the data redundancy and the trouble this can cause. Obviously he's never worked with databases in the real world as when there's a need for a "Salesperson2", it's almost sure that in the near future a "Salesperson3" will be requested by the users and all code can be changed, etc., etc.

Is the questioner helped by this ? Yes, in the short term, but it's sure he'll be back and that makes EE happy as they will continue to collect their $$'s.
For smarter people there are sites like bytes.com where the membership is for free and the experts are cooperating to provide the best answers.

Nic;o)
Still proud to be suspended from this "quality site" where wannabee experts rule and "quality" is just another word from the dictionary.
(The question can be found at: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23996147.html)