Monthly Access Sales Report

[lsearcey]

I have a database made up to track customer sales information and would
like to be able to create a report that lists the sales for a
particular month i.e. May. This would list the sales person,Access Rate and
Month. I am new to access so I don't know a alot of the terminology of
all the features and menus so I don't know if is possible to do what I
want to do. I have a query and a report already but it lists all the
months not just a select month. Thanks for your help.

[/img]

 

[lsearcey]

Here are some of the screen shots of the report and database

 

[Royal Presence]

One idea would be to use sorting and grouping on your report. You can then sort by Month.

 

[lsearcey]

If I do that will it list just one month or will it list all of the months? Here are the links to screen shots that didn't show up earlier. Thanks

http://www.geocities.com/msclincoln/MSCdatabase.jpg
http://www.geocities.com/msclincoln/MSCdatabaseQuery.jpg

 

[bat17]

you can add a criteria to your query to filter it to just the relevant dates.

HTH

Peter

 

[lsearcey]

In the criteria I would put for example for the month of June 6/**/04 to get all the sales for the month of June. My date field is mm/dd/yy. Or is their another way to do it. Thanks

 

[bat17]

Have a look at http://www.mrexcel.com/board2/viewtopic.php?t=92574 for a similar problem

peter