[AccessD] Range of Values in Access Switch Function

David,

I had not thought of this approach.  

Thanks for the help.

Brad


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, September 16, 2010 3:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.