currency data type

[Dylan Moran]

I have not worked with the currency values in MS Access before.
However now I find myself having to now include this information in a
database.
My question is simple, I assume I use the currency data type and not number.
Are there any quirks, hints, traps or tips anyone has with working with the
currency data type.

I will have to do calculations such as totals, differences, grand totals etc
for various recordsets and individual reocrds.

If there is nothing of note that springs to mind, ignore my post and thatnks
for reading.
I understand I have not posted a specific question, but thought I just might
canvass the subject before diving in and find out later that 'you should have
done XYZ ... everyone does that'. You feedback, time and experience is
appreciated.

 

[Allen Browne]

Go ahead and use it. The currency type is reliable in all versions of
Access.

Internally, Currency is a fixed point number, i.e. it always has 4 decimal
places stored regardless of how the value is displayed. In Australia, that
equates to hundredths of a cent. If you are storing calculated results, you
may want to round to 2 places before storing so you don't get rounding
errors when totalling later.