Getting average of columns

[sdpsc]

I have a table in Access with columns 'm' and 'j', and I need to run a query to put the average of those two columns in another columns. Here is what I tried:

update table set average =(m+j)/2;

This, however, completely cuts off the decimals, even though the 'average' column is set for 3 decimals. How do I get this to work correctly (or is there a better way to do this)? Thanks!

 

[PHV]

What are the type and the field size of the average column ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sdpsc]

It is a number type, long integer.

 

[PHV]

Long integer hold only integral parts of number.
Choose either Single or Double.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sdpsc]

That was it! Thanks PHV!