Decimal and rounding issue? 1

[Apollo6]

I am using Access97...

I have a table that has a Number field with the following setup, Single, Fixed, 2 decimal places. I have several records that have the following issue:

Actuall value in field is -0.009994895
Display value in field is -0.01

The value I want is -0.01

I am exporting this data into a comma delimited file to be imported into anther system. However, when the flat file is built, it doesn't use the -0.01, it uses the -0.009994895. How do I "hardcode" the value to the rounded number. Can I do an update query against the table to hardcode the values? Any suggestions are appreciated.

 

[SkipVought]

Apollo6,

Here's what I would do to assure 2 decimal places...
[tt]
=INT(([YourField]+0.001)*100)/100
[/tt]


Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Apollo6]

That's exactly what I needed. Thanks a lot!!!