adding values of two columns to create a new column in table

  • Thread starter Thread starter kendrav
  • Start date Start date
K

kendrav

Hi,

I haven't been able to figure this out via the help menu or
my Access 2002 manual, so I thought I would posit my
question here:

I am working with a table in Access 2002 and I want to add
a new column. I want the values in this column to be the
sum of the values in two adjacent columns. For example,
the value in Row 1 of column A should be equal to Row 1 of
column B + Row 1 of column C.

How do I do this? In excel it is very easy to type this
equation right in to the cell, but in access, I can't
figure out how to begin with this one.

Thanks!
kendrav
 
kendrav said:
Hi,

I haven't been able to figure this out via the help menu or
my Access 2002 manual, so I thought I would posit my
question here:

I am working with a table in Access 2002 and I want to add
a new column. I want the values in this column to be the
sum of the values in two adjacent columns. For example,
the value in Row 1 of column A should be equal to Row 1 of
column B + Row 1 of column C.

How do I do this? In excel it is very easy to type this
equation right in to the cell, but in access, I can't
figure out how to begin with this one.
Click to expand...

That's because you don't do this sort of thing in tables. Tables are for your
core data storage. All calculations should be done on Forms, Reports or in
Queries. If you build a query that includes all of your existing table's fields
plus an additional calculated field, then you can simply use that query every
place that you would otherwise use the table and the calculated field will be
there for you to use..
 
Back
Top