Parameter Query - Showing fields in report

[Duncan Sibbald]

We would like our report to display the values that we enter into a
parameter query. At the moment our report works fine and returns the chart
which we want, but we would like to show what the query values which we used
were on the report itself.

AHGR

Duncan

 

[kingston via AccessMonster.com]

You need to either output the parameter as a field (in your query) or create
a form that holds the values. If you do the former, the parameter will be
listed in every record. If you choose to do the latter, you can open the
form (or use an existing form) with empty text boxes. When those text boxes
have data entered into them, the query can refer to those values rather than
prompting the user for a parameter via something like:

[Forms]![FormName]![Text1]

Then the report can also refer to those values.