Adding Parameters to a report Header

[rkrause]

I have serveral reports where in the query for the report i have for example Between [Enter a Start Date] And [Enter an Ending Date]
Is there a way to get what ever dates they type in the pop up box onto a report? if so let me know.

Also i have some reports that when they are run they have a form show up where they type in ther parameters, so in the querey i have something like this Between [Forms]![frmdetailbyTruck].[text0] And [Forms]![frmdetailbyTruck].[text2]
how would i get that type of parameter to show up on the report?

Thanks.

 

[boblarson]

1. Put a text box on the report header

2. set the text box's control source to
="Between " & [Forms]![frmdetailbyTruck]![text0] & " And " & [Forms]![frmdetailbyTruck]![text2]

 

[boblarson]

And make sure the form stays open for the report to use it (you can hide it, but it has to stay open for this type of reference to work).