Iif and Switch in Access Queries

[@josephpatrick5381]

Structured way of explaining. New to MS Access and using Switch function. Thanking you for utmost details, which I might have overlooked.

[@murtazaibrahim6560]

Hours of learning in minutes... Thanks for uploading.

[@wilsonfineart]

Great explanation. I use switch() but not often enough.

[@patrickbevernage2919]

Perfect it is new to me, and certainly useful.

[@ou812927]

Love the Don Quixote shirt

[@celsopereira9968]

Congrats for this class! Excellent! I have a question: Is this function available in every versions

[@codekabinettcomen]

Thank you for the feedback! Yes, I think the Switch function is in Access since Access 97! - A very long time.

[@karldonaubauer6898]

@@codekabinettcomen It's actually worse, Philipp! ;-) Switch() is part of Access since version 1. I think it was 1.1. as Access Basic only came with that version. In 97 only the number of possible expression pairs was enhanced (from 7 to seemingly unlimited). Similar for its sister Choose(). 18 years ago I wrote a (German) article about this kind of stepchilds (access-im-unternehmen.de/VBAFunktionen__ausgewaehlte_Stiefkinder/). However, you are certainly right that even nowadays many people still don't know them and torture themselves with nested Iifs. I see this all the time in forum discussions.

[@MarcosRieper]

thank you.

[@neojumpy]

it would have been enough to move the line "big customer" after "Excellent Customer"

[@codekabinettcomen]

I would have been in this example. I still think Switch is more readable and easier to maintain for complex expressions.

[@neojumpy]

@@codekabinettcomen i agree