#Error in Calculated control on my Report

L

Lori

I have a calculated control that returns an #Error when no records are found.
I would like it to return the following message in the text box instead: "No
Records Found."

How can I accomplish this.

Control Name: TotalVolume
Control Source: =Sum([Volume])
 
L

Lori

Never mind. I found my solution. I replaced my Control Source to:
=IIf([HasData],Sum([Volume]),"No Expiring FPA's.")

Thanks anyway!
 
B

Bill - ESAI

what is the "HasData" variable set too??

Bill

Lori said:
Never mind. I found my solution. I replaced my Control Source to:
=IIf([HasData],Sum([Volume]),"No Expiring FPA's.")

Thanks anyway!

Lori said:
I have a calculated control that returns an #Error when no records are
found.
I would like it to return the following message in the text box instead:
"No
Records Found."

How can I accomplish this.

Control Name: TotalVolume
Control Source: =Sum([Volume])
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Calculated Control in a Report 2
Sum DCOUNT Calculated Control 2
calculations in report controls 4
Show Parameter Information in Report Footer 1
Adding Plus/Minus Sign to Calculated Control in Report 1
Total or pre calculated column 5
IIF summing in report 4
Error value in calculated control when no records 1

Top