Setting Decimals with CREATE TABLE statement

[Bezzie]

I have the following statement:

'create a temporary table in ADO_UserData called IHGridSheet
mySQL = "CREATE TABLE IHGridSheet (" & _
        "IHDay VarChar(6) NOT NULL, " & _
        "IDate DATE, " & _
        "IActualWeight SINGLE, " & _
        "IExpectedWeight SINGLE, " & _
        "IWeightLoss SINGLE, " & _
        "IDeviation SINGLE, " & _
        "HDate DATE, " & _
        "HActualWeight SINGLE, " & _
        "HExpectedWeight SINGLE, " & _
        "HWeightGain SINGLE, " & _
        "HDeviation SINGLE)"


ADO_UserData.Execute mySQL

to create a table in my database (VB6, Access 2000 table and MS Jet 4.0). This works to create the table but...

How do I set the decimals for the SINGLE fields? I want to set 2 decimals. After creating the table with the above statement it is on Auto.