When no data

[Kathy]

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.

 

[Guest]

hi,
access reports have a no data event. put it there.
It on the report's property sheet.

 

[Kathy]

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

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.
.