vickiwells
Registered User.
- Local time
- Today, 00:55
- Joined
- Jun 30, 2000
- Messages
- 61
I'm getting #Error on a subform total, and can't figure out the problem. I've checked everything listed in the Help topic, and it all seems OK.
The field I'm totalling is a calculated field in the subform's query. If the record is marked as "Void" I don't want the amount included in the total, so my calculated field's expression is this: use Approved Amt: IIf([Void?]=0,Nz([Approved Amount],0),0). When I look at the field results in the query, they're all right. In the subform's footer I'm using a text box with this expression: =Sum([use Approved Amt]) but I get #Error as the result. Is there something in the query's calculated field that would be causing this? It's kind of complicated, but from everything I can find, I should be able to do a sum on it as long as it's in the underlying query. Any ideas?
P.S. The really weird part is that at one point, the totals showed up correctly in the subform. I saved it, thinking Great! Don't know what I did, but it's fixed. When I went back later, it was wrong again.
The field I'm totalling is a calculated field in the subform's query. If the record is marked as "Void" I don't want the amount included in the total, so my calculated field's expression is this: use Approved Amt: IIf([Void?]=0,Nz([Approved Amount],0),0). When I look at the field results in the query, they're all right. In the subform's footer I'm using a text box with this expression: =Sum([use Approved Amt]) but I get #Error as the result. Is there something in the query's calculated field that would be causing this? It's kind of complicated, but from everything I can find, I should be able to do a sum on it as long as it's in the underlying query. Any ideas?
P.S. The really weird part is that at one point, the totals showed up correctly in the subform. I saved it, thinking Great! Don't know what I did, but it's fixed. When I went back later, it was wrong again.
