Hi Everyone
Would some one please help to solve my problem with a calculation field?
As you can see from the attachment the field gives the sum of a total cost but does not save it in the data table. When running a query the total cost comes up as £0.00
What do I need to do to save the total cost to the table

Generally you should not save a calculated value. Simply repeat the calculation in the query, or on forms and reports.

Thanks pbaldy
just tried the calculation in the query did not work
I put the calculations in the criteria is this right?

No, put it in the select clause:

select myfield1, myfield2, myfield1 + myfield2 as MathCalculation, myfield3, myfield4, myfield3 & ' ' & myfield 4 as TextConcatenation
from mytable
where mycriteria;

No, up in the Field row in a new column. In design view it would look like:

TotalAmount: [Field1] + [Field2] + [Field3]

Thanks guys, problem solved, appreciate the quick responce

Sorry Guys !!! but on checking the ammounts it is only picking up the cost in the last field any suggestions please

Can we see the calculation?

Sorted the problem was that the other fields were also calculated
redid the calculations and everything works as you suggested

thanks very much for the help

Richard