Total in subform on main form

[Stacey]

I have a two part problem.

I have a main form and subform. The subform is tied to the main form by record id. All items with a like record id show on the main form with the same record id.

First part: I set up the total [Total Refund] field on the subform. It is as follows
=Sum([Client Amount])
However, this is totaling all the records for that field. I need it to only total the records with the like record id so that the total for just those records will appear on the main form.

Second part: Even with the total field totaling incorrectly, I tried to have it show up on the main form. But it gives me a #Name? error. The field is as follows = Forms![Additional Unresolved]![Total Refund].

Any help would be wonderful!

Thanks
Stacey

 

[kstarnes]

Stacy,

Unfortunately, I cannot help with your problem...but I think you can help with mine. I'm trying to figure out how to create a total in my subform. I'm very new to access so any details or help you could give would be much appreciated.

Thank you.

 

[Stacey]

On your subform, add a text box. In the text box, type =sum([FieldName]). Hope this answers your question.

 

[Stacey]

Sorry, a little more detail would probably help. Put the text box in the Form Footer.

 

[kstarnes]

thanks for getting back to me, I tried it and haven't had any luck. I get an error message saying that the on current expression I have entered doesn't work and I can't see the field in the form anyway.

I have someone looking at it though, maybe they can sort it out. Thanks again, good luck finding information about your question.

 

[dr223]

Stacey did you solve your problem as I have the same problem (First Problem).

For second problem: try this

= Nameofthesubform.Form!Nameofthetextboxofthesubformfooter

Put this in the control source of the text box on the main form.

This will bring the total client sum you will have to see if you can find away to sum a field based on another field. Thats what am looking at but stuck