Update query rounds answers to integer

[Randy Holloman]

Microsoft Access 2000 - Latest update applied.

I have a table with about 4 fields that are type Fixed - 4
decimal places, call them [Cost], [Units], [SqFt] and
[CostperSqFt].
When I update [CostperSqFt] to [Cost] / [SqFt], I get a
rounded integer answer with a decimal point and 4 zeroes.

For example, if [Cost] is 38900 and [SqFt] is 42000, the
answer should be 0.9261. The updated [CostperSqFt] field
contains 1.0000
If [Cost] is 38900 and [SqFt] is 97000, the answer should
0.4010. The updated [CostperSqFt] shows 0.0000

How do I get it to NOT round the number?

 

[[MVP] S. Clark]

Fields do not have a 'type' of Fixed. They only have a 'format' of that.

Determine if your data type is a Single or Double, which can handle the
decimal places.

If they do, then click in the results field, does it change to the decimal?
How about widening the column width?

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-