Number question

[johnboy7676]

I have a simple DB, and will be doing very basic number input with one
decimal. But, this will be exported and one of the lawyers
somewhere might import it into excel, and say, hey, there's a problem
because your numbers don't add up. Due to a 10 in an Access field,
but when its exported to excel, might show as .999999999 (don't know
if that is a valid example, but you get the idea).

To save myself some aggravation, what is best format to use for the
Number field (which is not currency):

Currency (which is how I usally setup Number fields requiring decimal,
whether actually currency or not)

Or Decimal?

Thanks, John

 

[Jeff Boyce]

Why have you decided that "currency" is not an appropriate number type?

"Currency" is actually a bit of a misnomer -- all it means is "4 decimal
places, no data storage rounding error". The situation with the .9999999
example you provided comes in when you use single or double number types. I
don't know if it also applies when you use "decimal".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[johnboy7676]

Sorry, I wasn't very clear. Not that Currency isn't an appropriate
number type, I use it all the time for non-currency number fields. I
was just wondering which would be better for Data that will be
exported, likely into Excel.

I've never used Decimal. As a more generic guestion, What is the
"preferred method" these days? For 4 digit precision or less, that
is.

Thanks, John

 

[Jeff Boyce]

I don't know what others prefer, ... I use Currency.

Regards

Jeff Boyce
Microsoft Office/Access MVP