Queries By Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find an expession that will return a record by month for a
query.

Such as I want a return of all sales for the month of March, using the the
SALE_DATE column in my query.

Thanks,
 
Nizz said:
I am trying to find an expession that will return a record by month
for a query.

Such as I want a return of all sales for the month of March, using
the the SALE_DATE column in my query.

Thanks,
Click to expand...

SELECT *
FROM TableName
WHERE SALE_DATE BETWEEN #Mar-1-2005# AND #Mar-30-2005#

The above assumes that all of the date fields contain midnight as the time.
 
Or, if you want to run multiple months at the time, just create a report that
groups by month. Access will walk you through the process,
Carolyn in Toledo, visit www.asno.org
 
Back
Top