dumb data type question
On Mon, 29 Mar 2010 14:36:50 -0400, "Mark Kubicki"
wrote:
i have a field [SortOrder] which is
data type - number
field size - decimal
format - standard
precision - 8
decimal places - 2
however, whn in datasheet view, if if enter a numer (let's say; 150.10,
Access immediately changes it to 150.00
Sorry to say, i give up, could someone tell me what i am doing wrong?
You need to set the Scale to 2. The misleadingly-named Decimal Places property
only controls the display, not the storage. Precision 8, Scale 2 will allow
entries up to 999999.99; you will want Precision 10 if you want to get up into
the ten millions.
--
John W. Vinson [MVP]
|