HELP ..Calculation Error ?? (Access 2000 SR1)

Topic

New Reply

PLEASE HELP ……………….I have a simple table with two fields both defined as Field Size = Double and Decimal Places = Auto for input of numeric values.

When using an expression in a query to calculate the variance between these two fields I receive strange results on some, but not all records. A snapshot of the results are listed below. The expression is [FieldA]-[FieldB] …. has anyone run accross this before?

Field A – Field B = Result
123345.87 – 123345.87 = 1.45519152283669E-11
1677.72 – 1677.72 = 2.27373675443232E-13
737.99 – 737.99 = 0

Reply | Quote

Replies

Are the values in fieldA and fieldB result of calculation or are they keyed in ?
Try to set the format to General number to see what’s really in the field.
You may have to round your values.
ROUND(number,num_digits)

Reply | Quote

Are the values in fieldA and fieldB result of calculation or are they keyed in ?
Try to set the format to General number to see what’s really in the field.
You may have to round your values.
ROUND(number,num_digits)

Reply | Quote