Adding two cells (fields)

  • Thread starter Thread starter RickyDee
  • Start date Start date
R

RickyDee

Ok, it's been a LONNNGGG Time. I forgot most of what I
knew about ACCESS when working with EXCEL for so long.

I have four columns:
Name, Number, Number, Number

I'd like to add the two 'number' columns on each row, and
put the results in the fourth (total) column.

For instance:
Column one is Joe
Column two is what Joe owes me
Column three is what Joe has paid
Column four is what Joe still owes me now.

This has GOT to be easy. Once I get an answer for this
one, I'm sure I can figure out the rest. Isn't like
EXCEL, is it?

Thank you, guys and gals,
Have a nice, sunny day,
RickyDee
 
You have to create a query to do this.

Add the name and the first two number fields to the query (you can delete
the third number field). Then enter the expression in an empty field cell in
the query design grid. This will look something like:

Total:[FirstNumberField] + [SecondNumberField]

(The word before the : is the name of the calculated field - Access will
automatically add something like Expr1 if you don't supply it yourself).
 
RickyDee

In Excel, you do this all the time. Not a good idea in Access.

A query gives you a way to always derive the sum of the two fields. But if
you calculate it and add it as a third field, how will you keep the three
fields synchronized? What if someone realizes a mistake and makes a change?
 
Back
Top