Hi everybody. I have a column defined as number in an access 2007 db. I set it as single with 2 decimal places. And in vba a variable that deals with this column is a single type. I'm getting whole numbers placed in the db instead of values like 2.5 for example. Can anyone give any suggestions on how to deal with this? Please.