Help with #Error in report.

[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

[Allen Browne]

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).

[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).