Adding multiple fields

[russell_piper]

I am a total noob to access and I have three fields that I would like to sum on a form.

Can anyone point me in the direction of how to do this. I have looked on help and it refers to the SQL or VB function.

I am using office 2003.

Thanks

Russ

 

[isildad]

Russ, Look at my post (just before yours) and if you need more help let me know.

 

[isildad]

Had time to type an answer for you

I will give your three fields the names:
Orange . Apple . Melon

In “design view of your form create a Text box.
While the text box is highlighted right click on it and on the line named “Control source” type the following
=([Orange]+[Apple]+[Melon])
Now edit the names of your three fields to whatever you have named them.
Let me know how you did, you are the first person I’ve helped since I’ve joined this forum.

 

[Andrew Fergus]

Following on from the suggestion from isildad, if there is a chance one of the three values is null (i.e. empty), then you could modify the formula as follows :

=iif(IsNull([Orange]), 0, [Orange]) + iif(IsNull([Apple]), 0, [Apple]) + iif(IsNull([Melon]), 0, [Melon])

to detect and correct any such "null" values.

HTH, Andrew.

 

[russell_piper]

Then if I want to use the field I have created in another sum how do I refer to it in a forumla.

If I take its name I get #Name? returned.

Thanks

Russell

 

[SydneyGeek]

If you want the sum of a calculated field, Access wants all the details again.
Example: You create a field called [Citrus] with the expression =Nz([Orange])+Nz([Lemon]). You then want =Sum([Citrus]) and Access gives you the Name error.
Do this: =Sum(Nz([Orange])+Nz([Lemon]))

Note: Nz is Null to Zero -- gets around the problem of adding blank fields.

Denis