By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

ERROR Message in report

P: n/a
I have created a report which includes a calculated field of the type
.....=Sum(QUANTITY]*[Expr1]) and the report also does a group total which
gives an overall sum for the report.
My problem is that when I run the report, if there are no records to return,
I get an ERROR message in a couple of the fields.
Is there anyway that I can eliminate this ERROR message when there are no
results from the underlying query.
Thanks for any help

Frank Murren
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Frank Murren wrote:
I have created a report which includes a calculated field of the type
....=Sum(QUANTITY]*[Expr1]) and the report also does a group total which
gives an overall sum for the report.
My problem is that when I run the report, if there are no records to return,
I get an ERROR message in a couple of the fields.
Is there anyway that I can eliminate this ERROR message when there are no
results from the underlying query.
Thanks for any help

Frank Murren

You can use the HasData property of your report here. Such as

=iif(hasdata,sum(quantity*expr1),"")

--
Bas Cost Budde
http://www.heuveltop.nl/BasCB

Nov 12 '05 #2

P: n/a
A short search in this NewsGroup found "Another #error in report". It
has several good solutions. You should search before posting. I
rarely come across a problem no-one else has experienced.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.