Results 1 to 2 of 2
  1. #1
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169

    Create a Primary Key field from a Make Table Query

    I am running a Make Table query that is creating a table without a primary key. None of the fields in the new table can be used as a primary key because all of the fields could potentially not have a unique value.



    My question is: Can a new field be defined in the make table query that will create a primary key with autonumber? If so, what would be the code to create that field? thanks much

  2. #2
    jpkeller55 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    169
    Actually, I think what I am going to do instead of using a make table query is to utilize an established table with PK and then run a combination of delete query and append query which should do what I am looking for. Thanks for looking.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Creating Yes/No Field Using Make Table
    By orcinus in forum Queries
    Replies: 6
    Last Post: 08-19-2010, 11:09 PM
  2. Field changes in Make table query
    By asherbear in forum Queries
    Replies: 9
    Last Post: 05-29-2010, 01:35 PM
  3. Replies: 2
    Last Post: 04-20-2010, 12:47 PM
  4. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  5. Replies: 1
    Last Post: 06-01-2009, 01:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums