When no data

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

Guest

I have a report that when there is no data, I want to print a report with a
msg.
=IIf([HasData]=0,"No data for Customer ") #### I have the customer # in a
table.
How do I add it to the report.
 
I have the no data part working, I do not know how to grab the Customer
number from the table and add it to the report

[email protected] said:
hi,
access reports have a no data event. put it there.
It on the report's property sheet.
-----Original Message-----
I have a report that when there is no data, I want to print a report with a
msg.
=IIf([HasData]=0,"No data for Customer ") #### I have the customer # in a
table.
How do I add it to the report.
.
Click to expand...
Click to expand...
 
Back
Top