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.
 
You must log in or register to reply here.

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

Totalling Rows and Columns in a Crosstab Query 1
How to use colmn headings in paramter query 2
total a query 1
How to set a "Gate" in access query 3
Date Format and Sumproduct 9
Totaling by Month 5
Max Values Query 5
Create a Calcuated field in a query 1

Back
Top