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

Access 2002 #ERROR

P: n/a
I have a report in which I have 2 subreports, each with a subtotal in
the report footer.
I'd like to add the 2 subtotals together in the main report.
If one of the subreports doesn't have data for a given record in the
main report, I get #ERROR.
eg;

INVOICE # 1
TOTAL
Unit 1 5 lbs $2/lb $10
Unit 2 3 lbs $3/lb $ 9
Sub Total $19

Extra charge 1 $4
Extra charge 2 $6
Sub Total $10

Grand Total $29

The units are in 1 subreport, the extra charges in another. If there
are no units or no extra charges for an invoice, the grand total shows
as #ERROR.

Does anyone know how to correct this problem?
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.