In Access, need to add number fields & do percentage from other -h

K

Karine

I have create a table with a number of text and number fields. From this, I
have created a form.
Now from some of my fields (set as number), I need to add them up; this sum
should be in a new field and stored in the table.
I also need to do a percentage from some of these fields.

I am not very familiar with modules but know how to do it in Excel; is there
a way of doing this in Access?
 
A

Arvin Meyer

You rarely need to store the results of a calculation in a database, and
never need to do so when all the elements of the calculation are already
stored. Using a form, report, or query, you can always recreate the result
of your calculation. On very large databases, with complex calculations,
sometimes an Insert (Append) query is used to build a temp table to run a
report or export data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top