Using a query parameter as a field in a report

[homer2002]

Hi

I'm trying to create a report that list stuff between 2 dates

in the query i have a line like this
_____________________________________

in 'critera' of a field called DateWorkDone

">=[Earliest Date] AND <=[Latest Date]"

so you get two dialog boxes asking for dates

______________________________________

i want my report to be able to reflect these two parameters in the header (only need to put it into a text box)

Does anyone know how you pass these parameters into the report
______________________________________

I tried using Control Source "=[Earliest Date]"
it didn't work obviously but it was worth a shot, huh
_______________________________________-

 

[antomack]

Setting the Control Source as you did should work. You will get the two prompts for the dates and they should appear on the report. I often use this in my Report Titles by creating a text box with the control source set to the title text concatenated with the parameters.

Example:
="Work done between " & [Earliest Date] & " and " & [Latest Date]

 

[homer2002]

Cheers, your right, it does work.

I must be going crazy