Brad Marks
BradM at blackforestltd.com
Thu Sep 16 15:34:13 CDT 2010
Is it possible to specify a range of values in a Switch Function that is
used in an Access query?
I have a Switch Function like this sample -
DerivedGroup: Switch([Product] In ("1","2","3","4","5"),"Product Group
One",True,"Default Product Group"))
I would like to specify a range rather than spelling out each possible
value
Something like =("1" through "5")
Thanks for your help,
Brad