print query prompts in report header when no data to report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ConfusedCraig - 30 Nov 2007 16:26 GMT

a report which uses a Query with prompts(expr1: xyz) and other criteria
selects no records. The report header prints, but (expr1) which is a field in
the header is blank. I want the prompts to print in the header even when no
data is found.

Reply to this Message

Duane Hookom - 30 Nov 2007 17:55 GMT

http://www.tek-tips.com/faqs.cfm?fid=6763
If you use references to controls on forms, the values will always be
available even if the query returns no records.

Signature

Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

> a report which uses a Query with prompts(expr1: xyz) and other criteria
> selects no records. The report header prints, but (expr1) which is a field in
> the header is blank. I want the prompts to print in the header even when no
> data is found.

Reply to this Message