Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: new table fields

    Is there a way to add a field to a table from a query. I have a few make-table queries where i would like to add new columns (fields). I remember i used to do this- Am I correct in thinking that it can be done?

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    you can use an ALTER TABLE query like this

    Code:
    ALTER TABLE TableName
    ADD newField Varchar(3);
    HTH
    Dave

  3. #3
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    thanks

    Thanks, DAVE!
    This works great.

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    If you use a CreateTable Query then write in any column
    yourNewFieldName : its Value
    i.e nPersent:10
    sPath:"C:\Horton\Utilities\"

Posting Permissions

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