Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#Error#

Status
Not open for further replies.

bkf7911

MIS
Mar 20, 2007
83
US
This has to be a simple something that i'm missing. I have a report that is based on a query. I don't want to see null values or zeros in the query that feeds the report. But when i put in this criteria, no records meet it, and i get #Error# on the report. My customer wants to see Zeros, but i'm showing Zeros for every line item in the report, when that is the case, and i don't need to see that either. I know this may make no sense, and that's because i'm tired of thinking about it.

Basically: How can i show Zeros instead of #Errors# when there are no records to report?
 
Do you mean something like:

[tt]=IIf([HasData],Sum([txtAmount]),0)[/tt]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top