Access 2007 - Calculations

The UK's most regular instructor-led training courses.
Training information: access vba · Access course microsoft training · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Kieron has attended:
Access Introduction course

by - delegate Kieron [1 post] (2008 Mar 17 Mon, 16:50) Reply

Can I manipulate data by simple calculations in access like in excel?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access 2007 - Calculations

by - trainer Pete platinum contributer [799 posts] (2008 Mar 27 Thu, 09:09) Reply

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

· Microsoft Access Courses
· MS Access: Access your Personal Information with Ease
· Learn about Subqueries in Access Courses
· Microsoft Access Tighten your Security Controls
· Material covered on a Microsoft Access Course

Please browse our web site to find out more about
access vba and other Microsoft training courses.

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips