converting website visitors
Microsoft Office Tip & Tricks Menu
Tip & Tricks Menu

Calculating Fields in Access 2010

Tuesday July 12, 2011 at 6:26pm

Access 2010 allows you to create a calculated field in a Table, rather than having to run a query or a report to carry out calculations. Where the calculated field refers to the values held in fields, those fields must be from the same table. The expression for the calculation is created in the Expression Builder.

• To create a calculated field in a table, switch to the Table Design View;
• On the Create Tab, select the Table Design button in the Tables group;
• Create the other fields, particularly those that will provide the data for your calculation;
• For your calculated field, enter the required Field Name and select Calculated as the Data Type;
The expression Builder will open to allow you to enter the Expression, selecting the appropriate Field Name, Operator, Function, and/or Constant .

Example expression: [Rate]*[Hours]
On each record, this field will multiply the value in the [Rate] field by the value in the [Hours] field.


Note that field names are enclosed in square brackets.

» Categories: Microsoft Access

Comments

There aren't any comments for this post yet. Why not be the first to comment?

Leave a Comment

Your Name
  
Email Address (kept hidden)
  
Website
 
Comment
  

So that we can check that you are a real person (and not a crafty computer),
answer this simple sum:

What is 18 - 3?
  
Intec Business Colleges - Established For Over 30 Years
Microsoft Office Specialists - Approved Microsoft Courseware
Intec Business Colleges Ltd, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net
Website Design by ZARR Ltd