Parameter in report header- possible?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'm designing a database to track work in various areas (sales, marketing,
etc.) for people who work in different areas at different times. I've
designed a report based on a "by department" query, where the user has to
enter the department as a parameter (field "Dept" in the query's design
contains under "Criteria" the prompt "=[Enter department]"). I'm looking for
a way to automatically place the parameter in the report header. That way,
when the user opens the report and types in the department (for example,
"Sales"), then "Sales" will appear in the header. This would allow me to
delete the "Dept" field from the report (since the output would be the same
in all records), and the result would be a cleaner report. Is there a way to
accomplish this in Access 2000? Thanks.

Dave
 
Dave said:
I'm designing a database to track work in various areas (sales, marketing,
etc.) for people who work in different areas at different times. I've
designed a report based on a "by department" query, where the user has to
enter the department as a parameter (field "Dept" in the query's design
contains under "Criteria" the prompt "=[Enter department]"). I'm looking for
a way to automatically place the parameter in the report header. That way,
when the user opens the report and types in the department (for example,
"Sales"), then "Sales" will appear in the header. This would allow me to
delete the "Dept" field from the report (since the output would be the same
in all records), and the result would be a cleaner report. Is there a way to
accomplish this in Access 2000?
Click to expand...


In report's, you can use a parameter the same as if it were
a field in the query.

Just use a text box in the report header section and set its
control souce **exactly** the same as the parameter prompt
string. In this case,
[Enter department]
 
Back
Top