If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
can i concatenate in access
can I create a field in a table which pulls the data from two other fields in
the table (in the way that the concatenate function in Excel works)? |
#2
|
|||
|
|||
You shouldn't store a concatenated value in a table. Use a query or other
means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
#3
|
|||
|
|||
It's just that I want the amalgamation of the 2 fields to be my primary key.
Field 1 can have duplicates and field 2 can have duplicates but the 2 fields together would be unique. "Duane Hookom" wrote: You shouldn't store a concatenated value in a table. Use a query or other means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
#4
|
|||
|
|||
You can specify more than one field as the primary key (or unique index).
-- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... It's just that I want the amalgamation of the 2 fields to be my primary key. Field 1 can have duplicates and field 2 can have duplicates but the 2 fields together would be unique. "Duane Hookom" wrote: You shouldn't store a concatenated value in a table. Use a query or other means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
#5
|
|||
|
|||
Duh! I didn't realise that. Thanks Duane.
"Duane Hookom" wrote: You can specify more than one field as the primary key (or unique index). -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... It's just that I want the amalgamation of the 2 fields to be my primary key. Field 1 can have duplicates and field 2 can have duplicates but the 2 fields together would be unique. "Duane Hookom" wrote: You shouldn't store a concatenated value in a table. Use a query or other means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
#6
|
|||
|
|||
can i concatenate in access
How do you do that? When I try the key just jumps from one field to the next.
TIA "shazzer" wrote: Duh! I didn't realise that. Thanks Duane. "Duane Hookom" wrote: You can specify more than one field as the primary key (or unique index). -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... It's just that I want the amalgamation of the 2 fields to be my primary key. Field 1 can have duplicates and field 2 can have duplicates but the 2 fields together would be unique. "Duane Hookom" wrote: You shouldn't store a concatenated value in a table. Use a query or other means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
#7
|
|||
|
|||
can i concatenate in access
While the table's open in Design view, hold down the Ctrl key while click on
the "gutter" to the left of each of the fields you want in the PK. That should highlight the fields. Once that's done, then click on the Key to set the primary key. The other option is to work through the Indexes dialogue. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "FBrnstrmr" wrote in message ... How do you do that? When I try the key just jumps from one field to the next. TIA "shazzer" wrote: Duh! I didn't realise that. Thanks Duane. "Duane Hookom" wrote: You can specify more than one field as the primary key (or unique index). -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... It's just that I want the amalgamation of the 2 fields to be my primary key. Field 1 can have duplicates and field 2 can have duplicates but the 2 fields together would be unique. "Duane Hookom" wrote: You shouldn't store a concatenated value in a table. Use a query or other means to display two field concatenated together like: FullName: FirstName & " " & LastName or a control source of =[City] & ", " & [State] & " " & [Zip] -- Duane Hookom MS Access MVP -- "shazzer" wrote in message ... can I create a field in a table which pulls the data from two other fields in the table (in the way that the concatenate function in Excel works)? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Attn MVPs: MS Access Issues Imposed By IT Dept. | Tiffany | General Discussion | 9 | September 12th, 2005 09:07 PM |
Ambiguous Name Error | pm | Using Forms | 10 | June 5th, 2005 09:19 PM |
2002 vs 2003 | Patrick Stubbin | General Discussion | 2 | May 17th, 2005 07:27 AM |
The "Right" web hosting for data access pages?? | Ron Ehrlich | General Discussion | 9 | May 6th, 2005 05:49 AM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |