Calculating a total in a new Form Field

J

Jimball

I have created a form based on a query and have four fields which populate
with a resulting number when a specific entry is provided in an entry field.
I want to create a Grand Total Field which adds the numbers from these four
fields. How do i do this, I have tried going to the control source and
selecting the field nmes to sum in the expression builder and I don't get
anything...

Here is the formula that I have used =[AH-64 TOTAL Fleece]+[CH-47 TOTAL
Fleece]+[Fuelers and 15X/Y/J series TOTAL]+[OH-58 TOTAL Fleece]+[UH-60 TOTAL
Fleece]

Please Help! Thanks
 
S

Steve

You say you have four fields you want to add to get a grand total but your
formula has five fields. Is it four or five fields you want to total?

Otherwise, if you are getting nothing, one of the fields is null. Change
your formula to:
=NZ([AH-64 TOTAL Fleece],0)+NZ([CH-47 TOTAL Fleece],0)+ ..... + NZ([UH-60
TOTAL Fleece],0)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
J

Jimball

That did it!!!!! Thanks Steve

Steve said:
You say you have four fields you want to add to get a grand total but your
formula has five fields. Is it four or five fields you want to total?

Otherwise, if you are getting nothing, one of the fields is null. Change
your formula to:
=NZ([AH-64 TOTAL Fleece],0)+NZ([CH-47 TOTAL Fleece],0)+ ..... + NZ([UH-60
TOTAL Fleece],0)

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]



Jimball said:
I have created a form based on a query and have four fields which populate
with a resulting number when a specific entry is provided in an entry
field.
I want to create a Grand Total Field which adds the numbers from these
four
fields. How do i do this, I have tried going to the control source and
selecting the field nmes to sum in the expression builder and I don't get
anything...

Here is the formula that I have used =[AH-64 TOTAL Fleece]+[CH-47 TOTAL
Fleece]+[Fuelers and 15X/Y/J series TOTAL]+[OH-58 TOTAL Fleece]+[UH-60
TOTAL
Fleece]

Please Help! Thanks
Click to expand...
Click to expand...
 
Top