asked on

Access SQL Create Table

Hi
I am trying to create a table with a Decimal column called "Test"
using the following code, but am getting a syntax error with:
[Test] DECIMAL (10,2),

CREATE TABLE tblTest
(CustomerID INTEGER NOT NULL,
[Test] DECIMAL (10,2),
[First Name] TEXT(50) NOT NULL,
Phone TEXT(10),
Email TEXT(50))

pdebaets

You can use CURRENCY which should automatically give you 4 decimal places, or DOUBLE, or SINGLE.

If you want 2 decimal places, use the table field DecimalPlaces property, Format property, or the format function.

Graham Mandeno

A field of type DECIMAL cannot be created in an Access database using DAO, but it can be done with ADO.

Instead of CurrentDb.Execute strDDL,
use CurrentProject.Connection.Execute strDDL

Best wishes,
Graham Mandeno [Access MVP 1996-2013]

Murray Brown

ASKER

Hi

Thanks. What would the full ADO code look like?

SOLUTION

Graham Mandeno

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Murray Brown

ASKER

Hi

I should have mentioned that I am building this in VB.net/VSTO