What (w/syntax ex.) is an alternative to multiple nested "IIf"s?

E

Exist2BMom

I've used multiple nested "IIf"s to have a report display say, the word Candy
if field value is "CY", and "Soda" if the field value is "SA". I had ten or
so nexted "IIf"s before Access told me the query was too complex. What else
is available? Thanks.
 
E

Eddy

Exist2BMom schreef:
I've used multiple nested "IIf"s to have a report display say, the word Candy
if field value is "CY", and "Soda" if the field value is "SA". I had ten or
so nexted "IIf"s before Access told me the query was too complex. What else
is available? Thanks.
Click to expand...

Try choose(value, choise1, choise2 .....)
or is this not applicable?
 
D

Duane Hookom

Create a table with values like
tblProducts
Abbr Title
===== =======
CY Candy
SA Soda
MG Magazines
BK Books
IC Ice Cream

Then you add this table to your query and join the Abbr field with your
field and include the Title field in your report.
 
E

Exist2BMom

Eddy,

Thanks so much... I think my explanation of the problem was a little lazy,
now that I re-read it... Duane's option is actually just what I needed...
thank you both so much!!
-Exist2Bmom
 
Top