How to get an instant sum

[ariansman]

I have the following form based on a table:

empName             salary            working
jack                     1000              yes/no
Steve                   1500               yes/no
Janet                   200                yes/no
summary:  [number]

fields “empname” and”salary” are locked, but the working is field is able the be switched between “yes” and “No” by the operator by a click.

Is it possible that the "summary" shows the instant sum of salaries of the employs whose working status is “yes”? For example all “working” are yes and summary shows 2700. But the operator clicks on the working status of Steve and changes it to NO, and the summary right away shows 1200.

i am not sure if this is doable on a form or report.
thank you

[JoeM]

The "summary" should be a calculated text box in the Form Footer section.
Use this as the Control Source to get it to do what you want:

=Sum(IIf([working],[salary],0))

It will update as soon as you move off the record you just updated (so it moves from "edit" to"submitted" status).

[June7]

Cross posted https://access-programmers.co.uk/for...d.php?t=300849