[AccessD] Range of Values in Access Switch Function

This isn't an answer to your question, but could you have a table with
the values?

tblTranslation
Num PKID (1,2,3,...)
NumWord text/char ("One", "Two", "Three"..._


Just join the table in when needed.

On Thu, Sep 16, 2010 at 1:34 PM, Brad Marks <BradM at blackforestltd.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>