Adding to Fields (1 Viewer)

[.Justin]

I want to add two fields in my table.

One field is called Product Cost and the other is called Postage Fee. I then have a field called Total Cost. I want to be able to enter the Product cost and the Postage fee and the total to be added together in the Total Cost field.

How do I do this? I am rather confused :banghead:

 

[RuralGuy]

The calculated field (TotalCost) should *only* exist in a query, not in the table.

 

[.Justin]

The calculated field (TotalCost) should *only* exist in a query, not in the table.

Okay so what would be the simplest way? What code do i put in the query? I also want it to add up on the form tho?

 

[veraloopy]

To update all your existing records, you would need to run an update query as RuralGuy mentioned.

Moving forwards, I would calculate this when entering the values on a form, probably in the After Update of the Postage Fee (or whichever of the 2 values is entered last... something like:

me.[Total Cost] = [Product Cost] + [Postage Fee]

 

[RuralGuy]

If the calculation is in the query (that is the RecordSource of the form) and you display the TotalCost query field in a control on the form then it will update as you change values the variable values. No formulas needed on the form. You would want to lock the TotalCost control so the user would not try and make changes there.