Solved Sum / Dsum

[Harry Taylor]

I have a running total TextBox (Text268) on a form

I have a subform (Expenses Subform) with vehicle history (Tyres, brakes, MOT etc)

I want my Test268 to give me the total expenditure from the subform.

I tried =Sum([Expenses subform]![Total]) but get an #Error

Can you help?

 

[June7]

Aggregate functions must reference field, not control, and must be on form with the field. So if field is named Total, simply in textbox in subform footer section (it will not show with Datasheet View): =Sum([Total]). Then textbox on main form references subform control: =[Expenses subform]![textboxname]

 

[Gasman]

And the error is?
Give your controls meaningful names.

 

[June7]

Gasman, the error is #Error showing in textbox.

 

[Harry Taylor]

Yes,

Below is a screenshot where the result should be £50

 

[June7]

Have you read post 2? I have edited it so might review again.

 

[Harry Taylor]

Sorted, thank you all.


I put the sum in the subform and all ok.

Thank you all