Here is my sql to create a new table in the database, problem is in the "Result" field, which I want to be double format, i.e. the user should be able to enter numbers with decimal points, e.g. 1.56

Problem is, after the table is created, when the user enters 1.56, it automatically gets rounded up or down!

Why is this, and how can I solve it?

----------------------------------------------------

cmd.CommandText = "CREATE TABLE " & txtSectorName.Text & " (TestNumber Long PRIMARY KEY, DateStarted Date, TestType Char(30), Result Double, DateFinished Date, SamplePoint Char(20), Sector Char(20), TestAddedBy Char(30), ResultEnteredBy Char(30))"

-------------------------------------------------------------------------

Result Double

should that be something else, e.g. Result Integer ??


thanks steven