I dont know much about creating a table with sql, But if it rounds it of then you should use the correct format such as

VB Code:
  1. aDouble = Format(####.###)

Something like that i am not 100% sure though. But it has to do with Format.