Sum of a field

[mana2]

Hi,

I have a field on a form that I'm calculating called Options Vested. I'm creating another field on the form called Total Options Vested where I want to total all the Options Vested for that Employee. The two fields don't exist in the table since I'm doing calculations.

I tried this but I get double the vested on the field for that record and it doesn't carry through to the other records for the employee.
=DSum("[Options Vested] ","[StockOptions]","[Employee]='" & [Employee] & "'")

Could you tell me what's the best way to do this?

Thanks so much.

 

[mana2]

Sum in footer

Hi,

I'm placing a unbound text control in the form footer that sums a calculated
field on the page.
I keep getting an Error. It's a subform so I want to get the sum of all records for that employee.
I tried =Sum([Options Vested] and I got an error. Also tried =Nz(Sum([Options Vested]),0) but also got an error.

Thanks