Compare records if not in this month, then use business process

[Lorlai]

I am not sure how to properly phrase this question, and as such cannot find any answers out there on google. I have a budget that I am using to run several reports. We have a business requirement that states any expense purchased in this month for the next month (say you buy a plane ticket that will fly in January, but you bought the ticket in December) will not be counted. I have a column [Period] that contains the budget date (the final day of the month), and I have a column for [Actual Usage Date] that I can use to compare the dates. However, I am not sure how to set a rule for them...

Period	Item Type	Actual Usage	Use Business Process
7/31/2012	Air	8/15/2012	Yes
7/31/2012	rental	7/11/2012	No
7/31/2012	rental	8/01/2012	Yes
7/31/2012	Air	7/16/2012	No

In the above example, the 1st row contains a plane ticket purchased in July, but not used until August. The business process should be used. The Rental was purchased in July and used in July, so does not need a business process.



Is there a way in access to compare this information?

Thank you for your help!

[June7]

You want to retrieve records where the month/year of Period and Actual are same?

SELECT * FROM tablename WHERE Format([Period],"mmyyyy") = Format([Actual Usage],"mmyyyy")