Need MS Acess help

[Kung Lau]

Hi, this will probably be extremely simple to anyone who knows Access but I need help.

I would like to know how I can produce a report for my boss when I have a few fields such
date the work order was received, the date the work is complete. I need this on a monthly basis
to count how many orders were received. Do I make a simple query? If so, what's the criteria to show
the dates to only check for?

Thanks

 

[bunker]

Tried using the report wizard yet?

 

[Kung Lau]

I have but don't I need to set up the query parameters to only show the current month or selected month for report first?

 

[EagleKeeper]

Use the query wizard to filter by date.

 

[Mavrick007]

Or have the filter prompt you for the dates you want before running any report.