Insert to SQL table -- numbers are changing

[cp950]

I did not even know how to search for this, though I did try...

I am using Access_2000 to collect user data. When done, I insert it into a SQL_2000 table. Access PRICE field is Currency, and the SQL field PRICE is Float. I am moving the data with a simple append query.

The kicker:
Access = 45.4750
SQL = 45.474998474121094

Why would Access or SQL alter a basic number upon import? How can I avoid this?

Thank you all in advance, for I am unable to find ANYthing about this silliness.
___Craig___

 

[PHV]

Be aware that a Float real number is only an approximation.
Doesn't SQL admits Currency or Money or Decimal type ?

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