Data type conversion

Does anyone knows which data type conversion is better to use for
numeric/double in Access?
When upsizing or using dts, sql server uses float with 8 precision. Should
it better be decimal with 2 digit left and 2 digits right the comma.
ThxIf float-8 does the job, then there's no reason not to use it. You should
format the output at runtime, not when you store it, so you're okay.
- Wm
--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri
"Ezekiël" <ezekiel@.lycos.nl> wrote in message
news:%23jeq61D3DHA.1760@.TK2MSFTNGP10.phx.gbl...
> Does anyone knows which data type conversion is better to use for
> numeric/double in Access?
> When upsizing or using dts, sql server uses float with 8 precision. Should
> it better be decimal with 2 digit left and 2 digits right the comma.
> Thx
>