How do I print criteria from a query used for zero records report

  • Thread starter Thread starter DRO
  • Start date Start date
D

DRO

I've created a report from a query that has changeable criteria (address
block number and part or all of street name). It is important to print out a
report, even if there are no records. The Address block is a calculated
field, and the Street Name is the other field that is filterd. I need
assitance in printing the critera in the zero record report OR the address
block and Street name. Thanks in advance
 
Assuming your "changeable criteria" are coming from controls on forms (which
they always should be), you can add a text box in the report's Page Header
section with a control source like:
=Forms!frmRptCrit!txtStreetName
 
Back
Top