Help

[Carlos]

I need some help in building these IF statements. can
sombeody help?

Using the "IIF" function, build an expression that will:
a) Return all "newsettledate" equal to 8/13/03 as "first
month"
b) Return all "newsettledate" equal to 9/13/03 as "second
month"
c) Return all other "newsettledate" values as "future
months"

 

[John Spencer (MVP)]

All on one line.

IIF(NewsettleDate= #8/13/03#, "First Month", IIF(NewsettleDate =
#9/13/03#,"Second Month, "Future Months"))

Now, this could be a definite problem in the future as you add more months.
Perhaps you should just add a table that contains the NewsettleDate and the
Equivalent text you want and use that in an outer join statement to your current
query. That way, all you need to do is add a record to the new table for #10/13/03#.