Need to add Autonumber Primary Key to Make Table Query

[clint6]

Is there a way to do this. I'm basically just making a new table from a query, but I need a primary key in this table. I'd like to have this done without editing the table after I create it with a query. Can I insert a column in the query, call it GradeID, and somehow designate this to be autonumber indexed with no duplicates before I run the query?

In the column field I could have the following: GradeIDthen what?)

Thanks
Clint

 

[MajP]

If I understand you are running a make table query to make a new table from a subset of the original table. If that is the case, with your new table go to design view and add a field "GradeID" and make it an autonumber. It will give a number to each record.

 

[jadams0173]

I don't know of a way to do it without using some VBA code to create the PK and the field.



I tried to have patience but it took to long! -DW

 

[MajP]

Oops did not see that you did not want to edit. If you want to do it by code then:

http://www.mvps.org/access/tables/tbl0016.htm

 

[clint6]

Thank You!