Good morning,

I'm trying to create a table in access 2010 using the following SQL statement in a query

CREATE TABLE zlu_Supervisor (
SupervisorID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY,
SupervisorCode text(5) NULL,
Description text(50) NULL,
ListOrder byte NULL,
Active byte NULL

It will end up as a lookup table by inserting Distinct information from another table via SQL. Unfortunately I can't create the table. I'm receiving error
"Query must have at least one destination field". This should be pretty straight forward. Any ideas on why I would be receiving this error?

I also tried to just CREATE TABLE zlu_supervisor to see if I could then insert the new columns. That didn't work either. Same error.

Thanks,

Jeff

This has been solved. The content had to be enabled for this DB.

Thanks,

Jeff