Adding values in 2 columns in Access

[omnittha]

Hi!

Here I need help from you all - I would like to add values in 2 columns and write them to a third column and get the avg value of the third column.

For Example:

ColumnA  ColumnB  ColumnC
 
1          5          6
 
2          6          8
 
3          7         10
 
Avg                    8

Now I would like to run a query on a table - to add column A and Colum B, writing the sum to column C and finding avg of values in Column C.

Thanks in anticipation of your help.

Regards,

Omnitha

[NeoPa]

There's really no point in writing ColumnC. Just display it instead.

Assuming a table :
Table Name = [tblMyTable]

ColumnA  Number
ColumnB  Number

...then the following SQL provides your initial results set :

SELECT ColumnA,
       ColumnB,
       ColumnA+ColumnB AS ColumnC
FROM tblMyTable

A query to show the average of ColumnC would need to be a separate query, and could be :

SELECT Avg(ColumnA+ColumnB) AS [Avg]
FROM tblMyTable