Show header

[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

 

[Duane Hookom]

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

 

[Guest]

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

 

[Duane Hookom]

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.

 

[Guest]

Thanks again!

Sorry but what is exactly the other way!

Dan

 

[Duane Hookom]

Check out this tutorial http://www.fontstuff.com/access/acctut08.htm

 

[Guest]

Thanks Duane, I will try!

Dan

Check out this tutorial http://www.fontstuff.com/access/acctut08.htm