SQL create data table Create Table --- decimal point problem

dazhi7042

I now have a statement that creates data with VB:
   cmd.CommandText = "CREATE TABLE line (id char (10), X1 float, Y1 float, X2 float, Y2 float);"
   cmd.Execute
In the design view of Access, you can see that the ID is a character type, the ID field length is 10, X1, etc., the field size is double precision, and the number of decimal places is automatic.

I would like to ask you heroes, how can float be changed to get 2 decimal places?
I used the method of Number (10,2) and it didn't pass.

dazhi7042

This question is relatively simple, but I haven't done it before, I don't know where to find information, please heroes to help.

mexidong

You first manually create a table in the database, and then export the script from SQL to see
Understand

514473404

Is getting SQL top, the same problem