I'm trying to set a primary key in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set a primary key in the queries tab of Access? I would
like to set the primary key before I run my select query or make-table query.
Is there a way to do this without having to go into the tables tab of the
database window? A clue in the right direction would be very appreciated.

Thank you.
 
Is there a way to set a primary key in the queries tab of Access? I would
like to set the primary key before I run my select query or make-table query.
Is there a way to do this without having to go into the tables tab of the
database window? A clue in the right direction would be very appreciated.

Thank you.
Click to expand...

What are you actually trying to *accomplish* here - what business
task?

A Select Query cannot have a primary key. A Primary Key is a feature
of a Table, a field (or combination of up to ten fields, in a Jet
database) which uniquely identifies the record. It's not uncommon for
people to get the idea that the terms "Primary Key" and "Sequential
Autonumber" are synonymous, but they emphatically are NOT; a primary
key can be of any datatype except a memo or OLE object, or can consist
of multiple fields.

Please explain what you need this for!

John W. Vinson[MVP]
 
Back
Top