Form Control Field - Sum criteria

[Red Kenny]

Hello,

I'm very basic at form usage.
My question is, how do I total a control field with criteria of another field.

My simple calculation in the control field is =Sum([Sales]). What I want to achieve is to only sum [Sales] if [Account] = X

Many thanks.

 

[alansidman]

Bind your form to a query and not the table. Then you can have the sum by setting the criteria for the Account equal to X

 

[Micron]

Use DSum function with criteria. To use form fields, maybe try the solution here. The proper syntax depends on what the field data types are, so rather than repeat, I just provided the link for now. Summing is usually ok when fields contain null, but I'd suggest using Nz function as well. Both are shown there.