Adding Numbers up in a form aka like excel

James.90

Registered User.
Local time
Today, 04:09
Joined
Nov 14, 2007
Messages
49
Hello

I have a form where in different fields along the same record i need to add the numbers up

http://img77.imageshack.us/img77/8530/problemuc6.png

That's an example of what i mean as you can see in my badly mspainted bottom i have got a little box that shows 56 for the hours worked

Is there anyway to do something like this in access

thanks in advance
 
In the total box put something like this:
=Nz([Monday])+Nz([Tuesday])+Nz([Wednesday])...
Change these days of the week to match the actual names of the fields you are using. Where the ... is, finish naming the fields you want added together. In case of Nulls in any of the fields, I would suggest using the Nz() function as shown.
 

Users who are viewing this thread

Back
Top Bottom