Access 2007 - calculation

Hi Enat, Thank you for your post, in answer to your question; a query, a form or a report can be used when creating a calculated field, any such calculations will automatically be recalculated each time the object is run. Follow these steps, create a new field or in the field row of the query design grid enter a name for the calculated field, separate the name from the calculation by using a colon (:) Type in the expression to be used in the calculation, if you use field names, they must be enclosed in square brackets ie: VAT:[UnitPrice]*0.175
The Vat must be expressed as 0.175 rather than 17.5%, because percentage signs are not allowed within calculations.
Once a calculated field has been created it can be used in further calculations eg Net Price:[UnitPrice]-[VAT]
I hope that helps, best regards Pete