parameter box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like a parameter box to pop up and ask for the beginning date and end date for that report. How do I get this to happen
Thanks
 
I would like a parameter box to pop up and ask for the beginning
date and end date for that report. How do I get this to happen?
Thanks
Click to expand...

Is a Query the recordsource for the Report?
If so, then in the Query, as criteria in the Date field, write:
Between [Start Date] and [End Date]
 
Fred I did it and it worked fine. Now how do I get the Beginning date and the Ending date to print on my Report

----- fredg wrote: ----

I would like a parameter box to pop up and ask for the beginnin
date and end date for that report. How do I get this to happen
Thank
Click to expand...

Is a Query the recordsource for the Report?
If so, then in the Query, as criteria in the Date field, write:
Between [Start Date] and [End Date]
 
Fred I did it and it worked fine. Now how do I get the Beginning date and the Ending date to print on my Report?

----- fredg wrote: -----

I would like a parameter box to pop up and ask for the beginning
date and end date for that report. How do I get this to happen?
Thanks
Click to expand...

Is a Query the recordsource for the Report?
If so, then in the Query, as criteria in the Date field, write:
Between [Start Date] and [End Date]
Click to expand...

Add an unbound text control to the report header.
Set it's Control Source to:
= "For sales between " & [Start Date] & " and " & [End Date]

The Text within the brackets must be identical to the bracketed text
in the Query.
 
Back
Top