Form Sum function

[undee69]

Good day again.

I am trying to use the =sum function on the form but i am not able to see the sum.

I have four columns: annual leave, sick leave, special leave and absent, and I want to sum each of them



These only works if i put zero (0) on each columns but not if there are null entry.
is there a way to work with it having null entries?

[Bob Fitz]

Please show us the expression you are using as the Control Source property in the textbox in the form's Header or Footer Section.

[smytelka]

What I have done before when I have to sum with Null fields is put an expression like this in: iif([" Name of Field"] is Null,0,[" Name of Field"])

Happy 2013

[Rawb]

What I have done before when I have to sum with Null fields is put an expression like this in: iif([" Name of Field"] is Null,0,[" Name of Field"])

Happy 2013

Yup, this is the way to go.

If you can, I'd change the Query your Form is based off of to return 0 if the Field is blank. If you can't, then you should be able to change the Form Controls themselves to something like =Nz([MyField],0) instead (where [MyField] is annual leave, sick leave, special leave, or absent).

That should solve your Sum problem.

[undee69]

Thanks for the input guys. I've work around with those expressions in my control and I got it working now. ^_^
Happy new year to all ^_^