paste parameter query input to report

[MLHab306]

Hi Happy New Year to one and all.

I hope I have a simple question. I am using a parameter query to input a range of dates.

HAVING (((Date_last_done.Date_last_done) Between [Beginning Date ] And [Ending Date ]))

I have a report based upon the query. The user has no access to the query with the exception of the parameter query input.

I would like to paste the user input into a report. Just for better looking printout.

Thank you in advance for your suggestions and time.

Mark

 

[GingerR]

instead of having the criteria of the query ask for the user input, you may want to create a small form for the user input with two text boxes:

txtDateFrom and txtDateTo labeled however you want.

then a button which launches the query. then your query will reference those two text boxes as the criteria. Then on your report, you can reference them too...

make a text box in the header of the report, with the control source:

"Report for dates " & forms!frmUserInput!txtDateFrom & " and " forms!frmUserInput!txtDateTo

 

[MLHab306]

Thank you for responding so quickly. I will give it a try when I am more awake.

Thank you again

Mark