By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,208 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 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.

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.