Passing parameter values to the report

  • Thread starter Thread starter Ian Tranter
  • Start date Start date
I

Ian Tranter

I have a report that shows different categories.
On running the report the user is asked for date ranges
i.e. start of week & end of week. After report has run
all categories are shown with the number of times each
has been used. How do I pass the parameter values to two
text box controls for start & end of week contained in
the Report Header?
 
Ian,
If the query parameters is written as:

Between [Enter Start] and [Enter End]

then, add an unbound control to the Report Header.
Set it's Control source to:

="For sales between " & [Enter Start] & " and " & [Enter End]

The text within the brackets must be identical to the query bracketed text.
 
Back
Top