Why won't it work

[wildcat]

I have a subform frmIncomSub that has five fields on it based on a qry

Fields are:
Identifier
Fundraiser
Date
Reimbursement
AmountRaised
AmountAvailable (caluculated Reimbursement * AmountRaised)

Identifier is used to link the Main Form and the subform. The query is based off of the Identifier to collect all the information that the participlar person raised.

My problem is I need to total the Complete Amount raised by each person which I have the code in a unboound text box in the footer of the form as =Sum([AmountRaised]). I am also trying to calculate the same thing with the Amount Available, but when I do that, it gives me "#Error"

Any idea why?

 

[missinglinq]

Since AmountAvailable is a calculated field, you have to use the expression in your Sum() function. Instead of

=Sum(AmountAvailable)

which I'm guessing you're using, you need

=Sum(Reimbursement * AmountRaised)

 

[John Big Booty]

I suspect that the reason you are getting this result is, that you are trying to Sum() a field that is being calculated on the form. What you will need to do is to calculate the field in the underlying query, and then Sum() that field on the form.

 

[wildcat]

Thanks - I got it to work. I appreciate the insight.

 

[missinglinq]

Glad we could help!