Unanswered: Make Table Query setting a Primary Key
I am trying to create a new Table using a MakeTable Query
using the following sql:
SELECT qCPPlannedStopsOnTargetTotals.WeekNumber, qCPPlannedStopsOnTargetTotals.Line, qCPPlannedStopsOnTargetTotals.Description AS Above, qCPPlannedStopsOnTargetTotals.[%] INTO mkCPPlannedStopsAbove
ORDER BY qCPPlannedStopsOnTargetTotals.WeekNumber DESC;
However i want the new table to have a Primary Key, (Week Number) can i set this as the table is made?
This is probabyl not what you're looking for but it may come in handy.
Unique index (numbers) - so not really declaring your primary key as what you want. Starting point perhaps, or a "there's no other way" answer
CREATE UNIQUE INDEX index_name
ON table_name (column_name)