Show header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I have a report based on a query that looks for invalid items for one
particular store; if the query does not return records I would like to show
in the report header the store no., city, etc.

How do I do that?

Thanks,

Dan
 
This depends on how you select "one particular store". If you do this by
referencing a control on a form then you can use the form/control name as
the control source of a text box on your report:
=Forms!frmStoreSelect!cboStore
 
Hi Duane:

Thanks!

When I run the report, I am entering the store no. criteria from the query
store number field, the report is based on.


Thanks,

Dan
 
Don't use a parameter query since you will not have success getting your
parameter on the report if the query doesn't return any records.
 
Back
Top