Create access primary key in existing query table (view)

**shabar** · 01-28-2013, 03:05 PM

Hi All

is it possible to create access primary key (like ID) in a query

If so how (SQL)

cheers

shabar

**rpeare** · 01-28-2013, 03:47 PM

why? If you're talking about creating a compound text value based on multiple fields yes, but primary keys are, by definition, bound to tables, not queries.

**shabar** · 01-28-2013, 08:59 PM

Thax for your clarification rpeare

cheers

shabar

Create access primary key in existing query table (view)

Thread Tools

Create access primary key in existing query table (view)

Similar Threads

I need to create an expression within the design view of a query.

How to write a query that changes the layout of an existing table

first create table in MS access data definition sql view

Create a Primary Key field from a Make Table Query

Using VBA create a new table from an existing table

Posting Permissions