[MS_AccessPros] RE: Case Statement

 

Bryan

Logically, a Select Case doesn't need to be in some kind of order unless you are doing something like (which is very bad practice)

Select Case myVariable

Case is < 5

Case is < 3

If myVariable = 2 the first Case would win even though the second Case is also true.

I've seen some common mistakes especially with age groups like 1-5; 5-10, 10-20. These all have overlapping ages. People who don't write code or write SQL statements don't see that flaw.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (6)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___