S seany Registered User. Local time Today, 15:44 Joined Sep 1, 2003 Messages 53 Sep 6, 2005 #1 Can someone please help with this, it6 is having problem creating number field with 2 Decimal places DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In decimal(10,2), Out decimal(10,2));"
Can someone please help with this, it6 is having problem creating number field with 2 Decimal places DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In decimal(10,2), Out decimal(10,2));"
W workmad3 ***** Slob Local time Today, 15:44 Joined Jul 15, 2005 Messages 375 Sep 6, 2005 #2 DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In NUMERIC(10,2), Out NUMERIC(10,2));" hopefully the above will help. You also might want to change the In fieldname to something else as In is an sql reserved word.
DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In NUMERIC(10,2), Out NUMERIC(10,2));" hopefully the above will help. You also might want to change the In fieldname to something else as In is an sql reserved word.
