Reports in access, only show certain dates

[austin316]

Ok, I am using MS access and have a simple database with one table.

The fields are:

ID
DATE
HOURS
CLIENT
TAX_CODE
WBS_CODE
TASK
DESCRIPTION

For my report I display only the Date (with monthly grouping), Client, Hours, and WBS Code.

I would like when the report fires up to ask a begin date and an end date, so thus, the report would show all clients from say 7/1/2005 to 7/15/2005.

Thanks in advance.

 

[KB]

You can create a prompt token in your query by adding a [tokenname] string to your query. This will then prompt the user for a value. The problem is the prompt will be just a textbox, it won't show a date picker. Instead you can create a form with a date field and when you click on a button on the form, have it launch the report and pass the date as a filter.

 

[austin316]

Originally posted by: KB
You can create a prompt token in your query by adding a [tokenname] string to your query. This will then prompt the user for a value. The problem is the prompt will be just a textbox, it won't show a date picker. Instead you can create a form with a date field and when you click on a button on the form, have it launch the report and pass the date as a filter.

Sounds a little tough for me, I'm a noob, but looking through access, it looks like what I should focus on is the "Group On" command. However, it only gives me the following options --> each value, year, qtr, month, week, day, hour, minute.

 

[KLin]

Originally posted by: austin316

Originally posted by: KB
You can create a prompt token in your query by adding a [tokenname] string to your query. This will then prompt the user for a value. The problem is the prompt will be just a textbox, it won't show a date picker. Instead you can create a form with a date field and when you click on a button on the form, have it launch the report and pass the date as a filter.

Sounds a little tough for me, I'm a noob, but looking through access, it looks like what I should focus on is the "Group On" command. However, it only gives me the following options --> each value, year, qtr, month, week, day, hour, minute.

Just change the query that the report is built on. For the date field criteria put something like this: Between [Start Date] And [End Date].