Query last 365 days or 12 mo.

G

Guest

What is the proper syntax to request data for the last 365 days, or 12
months, whichever is easiest. Thanks so much for the wonderful resource!
 
T

Tom Ellison

Dear V:

The best choice is the DateAdd function. Using months and -12 or year
and -1 will be the same. Using Days and -365 will be the same except
for leap years, when it will differ by one day.

You should be albe to get help from Access for the DateAdd function
for full details.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Fri, 29 Oct 2004 06:40:02 -0700, "V. Terry" <V.
 

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

Top