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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding blank records in the detail section of a report 1
Print Query-Report Sections so the Printer will STAPLE each?? 1
Line breaks in a report 1
Word Create a Phone Book using MailMerge in word 2007 0
address labels to eliminate a city 3
How do I format postal addresses in an access report. 1
Accessing query fields from code with in a report 5
Access Dcount (multiple criteria) 3

Back
Top