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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the corilation beteen Left and Right Joins in the Join Properties dialog box? 1
Compare two columns in same table; result in 3 column 4
Access query translate to SQL Server 1
Excel Comparing two columns 1
Multiple supervisors over a date range in query 1
Count or sum help on query 1
Using iif() wtih different data types - Text & Memo 4
Help with small result type 2

Top