Adding fields

[FuneralofSmiles]

Can anyone tell me how I would go about adding together a particular field in a database?

Thanks.

 

[BlueOysterCult]

How do you mean?

Insert into - just off the top of my head... is that what you mean?

R

 

[FuneralofSmiles]

What I mean is adding all the cells in a field that contain numerical data and stores them in a variable on form load or change.

Such as an expenses database that has a 'Deposits' field and an 'expense' field. During formload adding all the cells in each field that actually contain data, storing each in a respective variable and then subtracting expenses from deposits an displaying overall balance in a label.

I still can't figure how to do this. Any help would be gratefully appreciated.