Click to See Complete Forum and Search --> : [RESOLVED] access 2007 vba losing value


viperbyte
January 17th, 2010, 02:11 PM
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.

viperbyte
January 17th, 2010, 03:42 PM
Never mind about the above question. I had a variable defined as long that was messing me up.