How to make the sum of two fields of a an Access table

[MrBaRRon]

Hi everybody,

I would like one field in an Access table be the sum of two others fields in this table.

Thank U.

 

[KenReay]

Hi

First of all don't do it. There is no need to store such a value you can calculate it in a query

make a query based on your table, make a column:

MySum:Value1 + Value2

of in SQL terms

SELECT *, Value1 + Value2 As MySum FROM MyTable;

run the query

see what I mean

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[MrBaRRon]

Ok you are right, their is no need to create a field in the table to make the sum... I have tried as you say and it's ok.

Thank U very much for your interest.