Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Red face Unanswered: Access 2010 Create Table SQL query error

    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

  2. #2
    Join Date
    Sep 2004
    Posts
    2

    solved

    Quote Originally Posted by jeff061768 View Post
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •