Is it best to use Currency or Number for dollar values?

[UpstateWeb]

I have been using Currency as the data type of choice for allowing clients to
update dollar values (rate, fee, price) into an MS Access database. It seems to
me though that I should be using just a number field. Then use CF to handle how
it is displayed. Does any body have any words of wisdom on this?

If so, what is the 'Best' way to define the number data type? (Long Integer,
Integer, Double, Decimal, etc..)

Thanks in advance,

Rock Moore

[BKBK]

I would stick with Currency , especially as your clients need to interface
directly with your database. Then, use Coldfusion to strip out the currency
symbol if and where necessary. This seems to me a more intuitive approach,
involving much less work than the change you propose.

[JMGibson3]

If you DO decide on non-Currency, be aware that even though stupid Access
allows you to specify decimals on Integer and Long Integer (should be greyed
out IMO), when you actually insert something with decimals, the decimals are
tossed.