Insert new field/Value in a make table query

[VegaLA]

Hi all,
stumped on an issue I thought would be pretty straight forwards (again) so i'm hoping to find the answer here! I have a make table query which produces the table using fields from three other tables and it runs fine however I now want to insert a new field with the value "Current" in it, and, if possible, an Autonumebr ID field as primary key. I'd like this is all done in one query so not sure if it will fly but if anyone can advise me I know someone from here can help.

Thanks in advance,
Mitch......

 

[Jon K]

The first part is rather straight forward. You can simply add
NewFieldName: "Current"

in the Design View of the make-table query.


To add an autonumber primary key field, you need to run a separate Alter Table query after running the make-table query. Something like ...

Alter Table [MyNewTable] add column [MyID] Counter CONSTRAINT [MyID] PRIMARY KEY


The MyID autonumber primary key field will be added at the end of the table. If you need it at the beginning of the table, you may run another make-table query.
.