Date Selection

  • Thread starter Thread starter Jimmy W
  • Start date Start date
J

Jimmy W

I have a report based on a query and need to be "asked" what date to use for
the data selection. What is the easiest way to do that?
 
Jimmy,
Many ways to do this, but the easiest is a parameter query. Open up the
query and in the criteria line of the date field, enter a question within
square brackets. Something like [Enter Start Date: ]. Now whenever you open
this query it will pause and ask for a date.
 
I have a report based on a query and need to be "asked" what date to use for
the data selection. What is the easiest way to do that?
Click to expand...

Why do you need to be asked?
Here is a better solution to select a range of records based upon a
date.

You'll need to use a form to do this.

First, create a query that will display the fields you wish to show in
the report.

Second, create a report, using the query as it's record source, that
shows the data you wish to display for ALL records.

Next, make a new unbound form.

Add 2 unbound text controls to the form.
Set their Format property to any valid date format.
Name one "StartDate".
Name the other "EndDate".

Add a command button to the form.
Code the button's Click event:
Me.Visible = False
Name this form "ParamForm"

Go back to the query. As Criteria on the DateField, write:
Between forms!ParamForm!StartDate and forms!ParamForm!EndDate

Code the Report's Open Event:
DoCmd.OpenForm "ParamForm" , , , , , acDialog

Code the Report's Close event: **
DoCmd.Close acForm, "ParamForm"

Run the Report.
The report will open the form.

Enter the starting and ending dates.
Click the command button.

The Report will display just those records selected.
When the Report closes it will close the form.

** If you have additional reports to run, using the same date
parameters, as long as this form remains open, you can run the other
reports and you will not be prompted for the date range. So... don't
close the form until the last report is run.
 
A parameter query might be the easiest but IMHO, probably one of the worst.
Read http://www.tek-tips.com/faqs.cfm?fid=6763 to find out why controls on
forms are much better.

--
Duane Hookom
Microsoft Access MVP


Michael Conroy said:
Jimmy,
Many ways to do this, but the easiest is a parameter query. Open up the
query and in the criteria line of the date field, enter a question within
square brackets. Something like [Enter Start Date: ]. Now whenever you open
this query it will pause and ask for a date.
--
Michael Conroy
Stamford, CT


Jimmy W said:
I have a report based on a query and need to be "asked" what date to use for
the data selection. What is the easiest way to do that?
Click to expand...
Click to expand...
 
Back
Top