Monthly Reports

[lsearcey]

I have a report now that shows the sales for each person and the average of sales for each person but I would like it to list just a certain month instead of all the months.
For example I would like it to list the sales for each person and average for the month of June only. How would I go about doing that? Thanks for your help

 

[ChrisUK]

Can't possibly answer this fully without knowing what your table layout is.

The way to go about doing it would be to select and use a WHERE clause and a sales date between the first and last month dates or you could use the WHERE and IN clause and specify a month.

Show us the table layout and your current SQL statement and we'll help you some more.

Chris

 

[lsearcey]

The fields I am using are the Month field which uses mm/dd/yyyy format. Then the sales person field which is a text field.
Finally a field that lists the sale in dollar amount (i.e. $49.95) this finale field the amount is selected from a drop down menu.
Hope this can help clear up on what can be done. Thanks

 

[Norie]

Try using the Month function.

 

[lsearcey]

I'm really new to Access, where would you use it at in the report? Thanks

 

[cornishteeth]

Try this link. It may help

http://www.techonthenet.com/access/functions/date/month.htm

Frank