Access 2007 - Calculations

Hi Kieron, Thank you for your post, in answer to your question; if you wish to manipulate your data with simple calculations these can only be accomplished in a query, a form or a report, any calculations will automatically be recalculated each time the object is run. To create a calculated field;
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, +,-,* or /, if you use field names, they must be enclosed in square brackets ie: VAT:[UnitPrice]*0.175 a percentage must be expressed as 0.175 rather than 17.5%, as 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