Why use currency format in tables?

[Sketchin]

I am just wondering if there is an advantage to using a currency field type in a table, vs. just using a number field? This is assuming that I am not working directly in the tables themselves and am using forms to display the data.

Thanks

 

[SmallTomato]

"Use a Currency field to prevent rounding off during calculations. A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right. A Currency field occupies 8 bytes of disk space."
http://office.microsoft.com/en-us/a...-database-and-access-project-HP005274573.aspx

Not sure what the advantage would be vs using decimal though.

 

[Sketchin]

Perfect, thanks for answering my stupid question!

 

[Brianwarnock]

Its not a stupid question here we can see users suggesting the use of currency to avoid the rounding off

http://www.access-programmers.co.uk/forums/showthread.php?p=1238711&highlight=currency#post1238711

brian

 

[Galaxiom]

Not sure what the advantage would be vs using decimal though.

Like Currency, Decimal is a scaled integer. The main difference is that Decimal allows the Precisions and Scale to be adjusted so that any amount of the precision can be used to represent digits after decimal place.