I am confused. How does a control with a control source of:
=Sum([Extended Cost])
cause a message "No Data" to appear?
Are you working with expression in a single main report with no subreport?
Does your question involve only one control or multiple controls?
What are the control properties and section:
Control Name
Control Section
Control Source
What do you expect to see?
--
Duane Hookom
MS Access MVP
--
Kathy said:
I have a report that is created with a table.
The Control name is REPTOT, control source is a calulation is
=Sum([Extended
Cost]). When there is no data the message appears "No Data" and in the
REPTOT field I get #error. I have tried every thing I know to get a zero
to
print when there is no data.
Duane Hookom said:
I can't see your control sources, control names, conditions, or what you
have tried in order to troubleshoot this...
--
Duane Hookom
MS Access MVP
The info worked fine but now I get #error in the detail for part number
and
report total. Can you help me with this.
:
Add a text box to your report header with a control source of:
=IIf([HasData]=0, "No Data To Print","")
--
Duane Hookom
MS Access MVP
--
I have a report that prints transactions. if there are no
transactions I
would like to print a report with a message that states No
transactions.
How
can this be done