M
Megan F via AccessMonster.com
Hi,
I have an invoice with 2 detail reports. One is for regular products and the
other is for special items.
I have a purchase order form that works fine. You enter the items, they
multiply and total add tax if applicable, etc. Everything is fine.
But when you try to print the invoice, the totals don't carry down.
It may be syntax but all of a sudden I'm getting a "too complex" error
message.
Originally I was pulling from the form directly to get the values, then I
thought I should try the sub reports.
I'm getting "0" as my total so obviously Access thinks the total is null.
Here's what I have -
=IIf(IsNull([rptExtendedDetails]!SumProdDetails),0,[rptExtendedDetails]!
SumProdDetails)+IIf(IsNull([rptSpecialDetails]!SumSpecDetails),0,
[rptSpecialDetails]!SumSpecDetails)
suggestions?
thanks.
I have an invoice with 2 detail reports. One is for regular products and the
other is for special items.
I have a purchase order form that works fine. You enter the items, they
multiply and total add tax if applicable, etc. Everything is fine.
But when you try to print the invoice, the totals don't carry down.
It may be syntax but all of a sudden I'm getting a "too complex" error
message.
Originally I was pulling from the form directly to get the values, then I
thought I should try the sub reports.
I'm getting "0" as my total so obviously Access thinks the total is null.
Here's what I have -
=IIf(IsNull([rptExtendedDetails]!SumProdDetails),0,[rptExtendedDetails]!
SumProdDetails)+IIf(IsNull([rptSpecialDetails]!SumSpecDetails),0,
[rptSpecialDetails]!SumSpecDetails)
suggestions?
thanks.