Query last 365 days or 12 mo.

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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.
 
Back
Top