Parameters

  • Thread starter Thread starter Penny
  • Start date Start date
P

Penny

I have a parameter in a query to ask for a year. I have
this query attached to a report. When you bring that
report up and the parameter ask for the year is it
possible to have the parameter list all the years that are
in the query then select that year instead of typing the
year in?


Thanks in advance

Penny
 
I have a parameter in a query to ask for a year. I have
this query attached to a report. When you bring that
report up and the parameter ask for the year is it
possible to have the parameter list all the years that are
in the query then select that year instead of typing the
year in?

Thanks in advance

Penny
Click to expand...

Why not just use the year that was entered in query parameter?
If the query parameter prompt was [Enter Year], then add an unbound
control to the report header.
Set it's control source to:
="Sales per store for the year " & [Enter Year]

Note: the text within the brackets must be identical to the bracketed
text in the query.

The year entered when the query prompts will automatically be shown in
the report.
 
Back
Top