#error whne printing a report with no data

I added a text box to the report header with a control source of:

=IIf([HasData]=0, "No Data To Print","")

The code worked great but now I get #error in the detail line for part
number and
report total. How can I fix the #error. I need the report to print for an
audit.

Use the IIf() expression with the HasData property in each expression, e.g.:
=IIf([HasData], Sum([Amount]), Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Kathy" wrote in message
...
I added a text box to the report header with a control source of:

=IIf([HasData]=0, "No Data To Print","")

The code worked great but now I get #error in the detail line for part
number and
report total. How can I fix the #error. I need the report to print for
an
audit.

I am new to MS Access, Can you please look at the code, I still can't get it
to work
=IIf([HasData], Sum([extended cost]), Null, No 41/81 Transactions for
specified date range")

I need a report to still print even though there is no data for audit
purposes.

"Allen Browne" wrote:

Use the IIf() expression with the HasData property in each expression, e.g.:
=IIf([HasData], Sum([Amount]), Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Kathy" wrote in message
...
I added a text box to the report header with a control source of:

=IIf([HasData]=0, "No Data To Print","")

The code worked great but now I get #error in the detail line for part
number and
report total. How can I fix the #error. I need the report to print for
an
audit.

What is:
No 41/81 Transactions for specified date range"

IIf has brackets.
Inside the brackets are 3 things separated by commas.
The first is something to test - [HasData] in your case.
The 2nd is what the show if there is data, e.g. a calculation.
The 3rd is what to show if there is no data, typically Null.

The previous example illustrates those 3 things.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Kathy" wrote in message
...
I am new to MS Access, Can you please look at the code, I still can't get
it
to work
=IIf([HasData], Sum([extended cost]), Null, No 41/81 Transactions for
specified date range")

I need a report to still print even though there is no data for audit
purposes.

"Allen Browne" wrote:

Use the IIf() expression with the HasData property in each expression,
e.g.:
=IIf([HasData], Sum([Amount]), Null)


"Kathy" wrote in message
...
I added a text box to the report header with a control source of:

=IIf([HasData]=0, "No Data To Print","")

The code worked great but now I get #error in the detail line for part
number and
report total. How can I fix the #error. I need the report to print
for
an
audit.