Calculating a total in a new Form Field

[Guest]

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

 

[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
(e-mail address removed)

 

[StopThisAdvertising]

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
(e-mail address removed)

--
Steve, you have one of two choices:
-- Tell us you will stop advertising here, or...
-- get lost for another year or so...
http://home.tiscali.nl/arracom/whoissteve.html
(Until now 2500+ pageloads, 1840+ first-time visitors)

FYI: (this is also to inform those who do not understand...)
This is *not* about the sigline...although we do not 'love' it, we don't mind the current sigline.
But we will simply continue to hunt down *each and every* of your posts.

It is not relevant whether you advertised in *this* particular post or not...
Your pattern is: You post a few 'good' answers and then start to advertise again.

These groups are *not* your private hunting grounds!
You should know this by now.

ArnoR

 

[Guest]

That did it!!!!! Thanks 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
(e-mail address removed)

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

 

[StopThisAdvertising]

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
(e-mail address removed)

Hey Steve,

Look at the stats (Statcounter.com) to see the damage you have done to yourself.
Every time the link is shown, more and more people are reading about you.
http://home.tiscali.nl/arracom/SteveStats.html

Since you have been posting 'nice' the last couple of days the 'answering-machine' stops for now.
We will be watching you though...

ArnoR