Pass date parameter input to report 1

[zencalc]

Hello all;
I'm working on a report that uses parameter input on the date field of a table. What I've done is use the Criteria between (enter start date) and (enter end date) to pull the correct data. Which works well. I also created a subquery to count the total number and obtain the first date where there's data and the last date. And I threw that data on the report. But, if there are no records in the table with the first date, for startdate it returns the first date that there is data, and vice versa for enddate. I know that's working right; its my error, but I can't figure out how to get the date that's entered in the between criteria to the report. Any help is appreciated.
Thanks!
Z.

 

[PaulBricker]

The standard way to get a parameter into a Report is to put that same parameter in a textbox on the report. So, if your query parameter is
Between [enter start date] and [enter end date]
then the control source for the textboxes on the report would look like this

=[enter start date]

and

=[enter end date]

Or something like this if you want it all in one textbox

="Between " & [enter start date] & " and " & [enter end date]

Hope this helps.

Paul

 

[zencalc]

Thanks Paul. Have a star!
Z.