decimal vs. double

[Jennifer]

I apologize if this post comes up twice. I waited an hour, and it didn't
show up.

For field size, what is the difference btwn Decimal and Double? I want to
be able to enter data with a fixed number of decimal places and NOT have it
round. I want users to be able to enter 3 #s before the decimal and 2 #s
after, such as 697.23. If they enter 697.237, I don't want it to round up.
So, is there a way to restrict how many digits after the decimal point can be
entered and then prevent it from being rounded? Thanks,

Jennifer

 

[Rick Brandt]

I apologize if this post comes up twice. I waited an hour, and it didn't
show up.

For field size, what is the difference btwn Decimal and Double? I want to
be able to enter data with a fixed number of decimal places and NOT have
it
round. I want users to be able to enter 3 #s before the decimal and 2 #s
after, such as 697.23. If they enter 697.237, I don't want it to round
up.
So, is there a way to restrict how many digits after the decimal point can
be
entered and then prevent it from being rounded? Thanks,

Well that sort of requirement is exactly when you would use a Decimal
because with a decimal you can specify exacly how many digits overall and
how many places to the right of the decimal point. Unfortunately the
implementation of Decimal in Access has many flaws. I don't know all of the
specifics except that I know there are problems with sorting on them.

 

[Jennifer]

Thanks for the information. This was very helpful. I have read a little bit
about problems with the Decimal format. Do you know of any problems in data
transfer (from forms to tables or from Access exporting to another data
package) or does it only seem to be with sorting?