Hi, I am pretty new to using MS Access and still learning all its features.
I am using a simple report generation button on a form, which will call a query and find all records for a specific, user defined, date range.
In the query criteria I ask a simple >=[Start Date] AND <=[End Date]
For beautification purposes I would like to store that user input in a dynamic StartDateSearch and EndDateSearch field. The end
goal would be to use those fields to generate a header on the report that reads "Records from" [StartDateSearch] "to" [EndDateSearch].
Is there a way to save user inputs in this way, or write a subroutine within the criteria field of a query to allocate the input to a field on a report?
Thanks!