Adding a Date Range to a Report

R

RS

I would like to be able to add a date range to a report each time I create a
new instance of the report. Right now I have it set up to the report is tied
to a parameter query that allows me to enter a beginning date and an end
date.

Is there a way that I can have that date range appear at the top of the
report automatically each time I create a new report with the new set of
dates?

Any help would be much appreciated!!
 
D

Duane Hookom

You should really have a single report that allows users to enter criteria in
controls on a form. IMO, parameter queries are not appropriate user interface.

You can display the criteria on your report with text boxes with control
sources like:
="From " & Forms!frmDates!txtStartDate & " to " & Forms!frmDates!txtEndDate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top