You are here:

Using MS Access/MS Access 2010 Table Calculations

Advertisement


Question
In a table, how do I formulate the difference between 2 numeric fields as a percentage.  For example, my table must include the previous amount field, the current amount field, the difference between the two field,  as well as another field showing what that difference is in percent form. The first 3 fields are simple enough, but I cannot find how to set up the field that will show what percent the difference equals.

Answer
Because you DON'T do it in a table. As a general rule we don't store calculated values in tables. Such calculations should be done in queries. You shouldn't even store the previous amount, but pull it in a query.

Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Website: http://www.diamondassoc.com
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scottgem

Expertise

I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience

I've been designing databases for over 25 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

Education/Credentials
Brooklyn College BA

©2016 About.com. All rights reserved.