Running reports by entering to and from dates

[jferguson-onco]

I have a db that has surveys.
When the user enters the information a date is entered.
An old employee created this and created several reports that list
information sorted by location.
Now I've been asked to update the report so someone can enter a date range
and retrieve the information only on surveys completed during a date range.

I have relatively little experience in Access, can anyone point me in the
right direction.

If you need more info, please ask, not really sure what all to include here.
Thank you

 

[fredg]

I have a db that has surveys.
When the user enters the information a date is entered.
An old employee created this and created several reports that list
information sorted by location.
Now I've been asked to update the report so someone can enter a date range
and retrieve the information only on surveys completed during a date range.

I have relatively little experience in Access, can anyone point me in the
right direction.

If you need more info, please ask, not really sure what all to include here.
Thank you

If the Report does not already have a query as it's record source,
create one. Then, as criteria on the query's Date field, write:

Between [Enter Starting date] and [Enter Ending date]

Make this query this query the report's record source.

The user will be prompted to enter the start and end dates.
If the dates are stored in a non-U.S. date format, the dates must be
entered in U.S. date format of month/day/year.

 

[jferguson-onco]

Fred,
I apologize for the delay but I missed your initial response.
Thank you for the help, it does what you said it will but I may need to add
more information here.
There are a bunch of queries that were created, the report that I'm running
is based on subreports that are running the various queries.
I added the info that you had included below into a "Date" query and when i
run the query it asks for the to and from dates and it only displayes the
dates within that range.
I need to add this part to the report and get it to only display the
selected info - there are a bunch or calculations being performed in other
queries that are tied to this report.

Any suggestions?

Thanks in advance,

I have a db that has surveys.
When the user enters the information a date is entered.
An old employee created this and created several reports that list
information sorted by location.
Now I've been asked to update the report so someone can enter a date range
and retrieve the information only on surveys completed during a date range.

I have relatively little experience in Access, can anyone point me in the
right direction.

If you need more info, please ask, not really sure what all to include here.
Thank you

If the Report does not already have a query as it's record source,
create one. Then, as criteria on the query's Date field, write:

Between [Enter Starting date] and [Enter Ending date]

Make this query this query the report's record source.

The user will be prompted to enter the start and end dates.
If the dates are stored in a non-U.S. date format, the dates must be
entered in U.S. date format of month/day/year.

 

[fredg]

Fred,
I apologize for the delay but I missed your initial response.
Thank you for the help, it does what you said it will but I may need to add
more information here.
There are a bunch of queries that were created, the report that I'm running
is based on subreports that are running the various queries.
I added the info that you had included below into a "Date" query and when i
run the query it asks for the to and from dates and it only displayes the
dates within that range.
I need to add this part to the report and get it to only display the
selected info - there are a bunch or calculations being performed in other
queries that are tied to this report.

Any suggestions?

Thanks in advance,

I have a db that has surveys.
When the user enters the information a date is entered.
An old employee created this and created several reports that list
information sorted by location.
Now I've been asked to update the report so someone can enter a date range
and retrieve the information only on surveys completed during a date range.

I have relatively little experience in Access, can anyone point me in the
right direction.

If you need more info, please ask, not really sure what all to include here.
Thank you

If the Report does not already have a query as it's record source,
create one. Then, as criteria on the query's Date field, write:

Between [Enter Starting date] and [Enter Ending date]

Make this query this query the report's record source.

The user will be prompted to enter the start and end dates.
If the dates are stored in a non-U.S. date format, the dates must be
entered in U.S. date format of month/day/year.

I think.... you wish to show the date range in the report.
If that is so, then add an unbound control to the report.
Set it's control source to something like:
="For sales between " & [Enter Starting date] & " and " & [Enter
Ending date]

The text within the brackets must be identical to the bracketed text
in the query.

Now if you meant something else, please repost and try re-phrasing the
question so that someone who can't see your database will understand
what you wish to do.