View Single Post
  #1  
Old March 29th, 2010, 07:36 PM posted to microsoft.public.access.tablesdbdesign
mark kubicki
external usenet poster
 
Posts: 84
Default dumb data type question

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?
-mark

(when i first created this atble, the field [SortOrder] had an incorrect
data type of text; which was subsequently changed to number after a small
amount of data had already been entered...)