Query database for specific month

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

Guest

I have database in Access of salespersons, sales dates, customer. I would like to do a query for specific month for many years. Can seem to get it to work? Thanks for any suggestions.
 
In your query design, add a calculated field like:
Expr1: Month([SalesDate])
and in the criteria line for that field type in the month(1 for Jan, 2 for
Feb etc.) or an expression resulting in the desired month. Of course, you
will need to change SalesDate to the actual field name in the table.

HTH,
Nikos

R. Hopper said:
I have database in Access of salespersons, sales dates, customer. I would
Click to expand...
like to do a query for specific month for many years. Can seem to get it to
work? Thanks for any suggestions.
 
Back
Top