User defined dates into a report

[markizan]

HI,

I have a query [CustomerOrdersByDate] that requests user input for [CustomerID], a 'Start Date' and an 'End Date' for the [OrderDate] field.

the Report works fine, however I'd like it to be able to take the Start & End dates the user has inputted when running the report, and make it appear in the Report header
e.g. Orders Received from [CustomerID], Between {user defined}[Enter Start Date] And {user defined}[Enter End Date].

I have added a text box to display the results and played around with a few different expressions, etc... unsuccessfully so far, and as I'm not up to working with VBA code, I would appreciate some help!

 

[Michael J Ross]

Set the control source of the text boxes to [Enter Start Date] And [Enter End Date].

 

[markizan]

Thanks, couldn't see the forest for the trees.
I obviously overcomplicated it and was looking for something far more complex.
feeling a bit silly now, but thanks for setting me straight.