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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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.
 
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
 
Back
Top