Decimal places in number 2

[TimTDP]

I have a field whose field size is Single.
If I enter a value, e.g 7.39, and use this value in a query the value appears as 7.39169979095459.

This gives inaccurate results. e.g
15 * 7.39 = 110.85
15 * 7.39169979095459 = 110.88

This is causing problems with the results in my query.

How do I prevent this, and ensure that exactly 7.39 is used?

 

[SkipVought]

Use the Decimal Numeric type.

Skip,

_{[red]Be Advised![/red] A man who jumps from a bridge in Paris, is…
INSANE!}

 

[TimTDP]

I cannot enter decimal value. If I enter 7.39, it automatically changes to 7!

I am using Access 2000

 

[dhookom]

PMFJI did you set the Scale property when you set the field type to Decimal? This would allow storing numbers/places to the right of the decimal point.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]