Rolling 12 month date query assistance

F

fishy

I want to be able to run a query so that it shows the last 12 months data by
month.

Any ideas?
 
J

John W. Vinson

I want to be able to run a query so that it shows the last 12 months data by
month.

Any ideas?
Click to expand...

Any help with your table structure?

BETWEEN DateAdd("m", -12, Date()) AND Date()

as a criterion on your date field will get the last twelve months data. You'll
need to use a calculated field such as

TheMonth: Format([datefield], "yyyy-mm")

to group by the month.
 

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

Query the same table three times 0
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Monthly quantities to Weekly 1
Copy with delay 0
Rolling 12 month 9
Query for multiple due dates 9
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Countdown macro - display settings 2

Top