Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007 - calculation
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access 2007 - calculation
Resolved · Low Priority · Version Standard
Reply Tue 18 Mar 2008, 16:42Delegate Enat said...
Enat has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Access 2007 - calculation
how do you do calculation?
For upcoming training course dates see: Pricing & availability
RE: 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
|