Report to display Current Month Data and Previous X Month's data.
Posted on 2006-07-24
I am building some reports of data that is entered each month. I need to generate reports that contain the data for this month as well as the previous X months. I am having trouble with building the subtraction of these dates. I have a form with 3 dropdown menus. One for month (Jan, Feb, ...) one for Year (00, 01, 02,...), and one for Number of months (1, 2, ...).
How can I build a query off this so that when I select Feb 06 and previous 4 months a query gives me reports for:
Is there a way to subtract dates?