How do I combine Field1 + Field2 into Field3 in a table?

R

riotgear

I want to combine information from Field1 and Field2 into Field3 in a table,
not a query. The third field would be a Primary Key. I know it's not
necessarily advisable, but this info as a Primary Key is essential. Can
anyone help me?
 
J

Jeff Boyce

Don't! If you want Field1 + Field2 to be a (composite, multi-field) primary
key, do that in the table definition by selecting both fields and
designating them (combined) as the primary key. Don't create a new (third)
field just to hold the two fields repeated.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jeff Boyce

Highlight both fields at once in the table definition. Set them to be the
Primary Key. The combination of values will have to be unique. Note that
Nulls will cause problems.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

riotgear

Is there a way to do it, though? Not as a primary key, but to combine fields
in one table? I need it for the data type I'm doing.
 
R

Rick Brandt

riotgear said:
Is there a way to do it, though? Not as a primary key, but to
combine fields in one table? I need it for the data type I'm doing.

No you don't. Combine them in a query and then use the query everywhere you
would otherwise have used the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top