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

Help with #Error in report.

P: n/a
Ron
Hi All,

I've got an aging report where the detail is a subreport on the transactions
for a client. I've got a client name header/footer and the detail is
between those areas. One of the controls in the footer is a label for
"Total of current transactions = " and then the control for totaling the
transactions (that's a sum from the detail subreport's amounts). Then, it
ages it, etc. All works great--except when there are no current
transactions to list. The client will have a previous balance, no
transactions, and the aging. Unfortunately, of course the label prints (not
a problem) but the total is "#Error" and that prints also. Looks kinda
tacky.

Is there a way to allow it to print if this total is a valid number but not
print the "#Error" when it's not?

Info if needed: Access2000. Main report = rptAging. Subreport =
srptDetails. Controls on footer are lblTotalCurTrans and TotalCurTrans
(control source is TransTotal from srptDetails).

TIA for any suggestions.
ron
Feb 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Test the HasData property of the subreport.

Details in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ron" <ro********************@verizon.netwrote in message
news:A21yh.9772$MH2.4770@trnddc03...
>
I've got an aging report where the detail is a subreport on the
transactions for a client. I've got a client name header/footer and the
detail is between those areas. One of the controls in the footer is a
label for "Total of current transactions = " and then the control for
totaling the transactions (that's a sum from the detail subreport's
amounts). Then, it ages it, etc. All works great--except when there are
no current transactions to list. The client will have a previous balance,
no transactions, and the aging. Unfortunately, of course the label prints
(not a problem) but the total is "#Error" and that prints also. Looks
kinda tacky.

Is there a way to allow it to print if this total is a valid number but
not print the "#Error" when it's not?

Info if needed: Access2000. Main report = rptAging. Subreport =
srptDetails. Controls on footer are lblTotalCurTrans and TotalCurTrans
(control source is TransTotal from srptDetails).
Feb 6 '07 #2

P: n/a
Ron
That worked like a charm. Now that that problem is solved, I'm off to
tackle something else I don't understand.

Thanks Allen!
ron

"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:45***********************@per-qv1-newsreader-01.iinet.net.au...
Test the HasData property of the subreport.

Details in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ron" <ro********************@verizon.netwrote in message
news:A21yh.9772$MH2.4770@trnddc03...
>>
I've got an aging report where the detail is a subreport on the
transactions for a client. I've got a client name header/footer and the
detail is between those areas. One of the controls in the footer is a
label for "Total of current transactions = " and then the control for
totaling the transactions (that's a sum from the detail subreport's
amounts). Then, it ages it, etc. All works great--except when there are
no current transactions to list. The client will have a previous
balance, no transactions, and the aging. Unfortunately, of course the
label prints (not a problem) but the total is "#Error" and that prints
also. Looks kinda tacky.

Is there a way to allow it to print if this total is a valid number but
not print the "#Error" when it's not?

Info if needed: Access2000. Main report = rptAging. Subreport =
srptDetails. Controls on footer are lblTotalCurTrans and TotalCurTrans
(control source is TransTotal from srptDetails).

Feb 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.