Adding Fields

[vicky]

I have a table with two columns (JT1 and JT2). I want to add these together to form a new column in the table (JT Total).

I am new to Access and have tried looking up the sum function etc, but am struggling.

Can anyone suggest an easy way of doing this?

Thanks.

 

[MStef]

Hello vicky!

It is not necessary to save a data which you can calculate always you need it.

 

[stopher]

Hi Vicky and welcome to the forum

As Mstef says, it bad practice to try and store calculated values. Instead you make use of queries to calculate when you need to. Then you base your reports and forms on the query instead of on the table.

- create a SELECT query in design view
- add the required table to the view
- drag the fields you want dwon nito the query
- in an empty colum, add the formula:
JTTotal: [JT1]+[JT2]
- Save the query
- Run the query and see the result
- base your report of this query

Sorry if I'm stating the obvious here. Always difficult to gauge someones level of understanding.

hth
Chris

 

[vicky]

Thanks - not stating the obvious. My problem was that I was trying to fit in an equals sign in before my formula.

It is now working, so your help is much appreciated!

 

[PaulJR]

I was attempting to do this too when I was new to Access. As you become more familiar with Access you will find it is very different to Excel, and requries different thinking.