Comparing Data

Y

y2kfiveoh

Joined
Apr 27, 2009
Messages
1
Reaction score
0
Hi, I'm working on a query at the moment in which I need to compare data from the current month to the previous month. I obviously need an IIF function and really just need it to translate into TRUE or FALSE.

So something like If CurrentMonth.Actual > LastMonth.Actual, True, False. I'm not exactly sure how to translate that into SQL for Access 2007.

Thanks very much!

Best,
Todd
 
Last edited:
Back
Top