Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem with data type

Status
Not open for further replies.
Pokemarco

Pokemarco

Programmer
May 17, 2002
2
FR
Hi, I am developping a application with Access 2000, and I would like to know how to concatenate 3 fields in order to construct a primary key for my table .
thanks in advance
 
highlite the three fields and click the key symbol
Bastien

There are many ways to skin this cat,
but it still tastes like chicken
 
thanks
ok, that's already done, but I need to know how to make another field with the result of the concantenation. It will allow us to do simplier request on the base
 
keyfield = fld1 + fld2 + fld3
 
Status
Not open for further replies.

Similar threads

JayRo71
  • Locked
  • Question
Saved Imoorts problem with file name
Replies
10
Views
466
Andrzejek
Andrzejek
Anthony343242
  • Locked
  • Question
MS ACCESS UNION ALL with Attachment data type 1
2
Replies
29
Views
3K
Anthony343242
Anthony343242
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
378
SkipVought
S
jjMedrano
  • Locked
  • Question
UNION ALL with Attachment data type 1
Replies
8
Views
304
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Prevent new data being used when using Archive backend
Replies
0
Views
2K
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top