Access 2007 - calculation

Resolved · Low Priority · Version Standard

Enat has attended:
Access Intermediate course

by - delegate Enat [2 posts] (2008 Mar 18 Tue, 16:42) Reply

how do you do calculation?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: access 2007 - calculation

by - trainer Pete platinum contributer [799 posts] (2008 Mar 25 Tue, 10:33) Reply

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

· When Is Microsoft Access Not The Best Choice For Your Business?
· Microsoft Access Tighten your Security Controls
· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Microsoft Access, an Efficient Database Tool

Please browse our web site to find out more about
ms+access+course/ and other Microsoft training courses.

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips