dadesiboy
06-20-2000, 12:25 PM
In Microsoft Excel it is possible to use the concatenate function in order to make a series of attributes into one(exe: the, cat, walks, would be:"the cat walks") Is there any way of doing this in an access table. Because my goal is to simply make the primary key the combinations of three attributes. That woudl help me alot.. thanks
Pat Hartman
06-20-2000, 01:35 PM
You can define a primary key that contains multiple fields. Just Shift-Click to select each one.
I STRONGLY suggest that you do not combine three fields into one. It will ultimately cause more problems than it will solve.
Databyte
06-26-2000, 06:37 PM
The ampersand is the concatenation function
[field1]&[field2]&[field3]=field1field2field3
dadesiboy
06-27-2000, 12:25 PM
Where do I put that line in? In the format area of a table.. im confused. I just started databasing about a month ago, so I need alot of detail. tHanks
Databyte
07-03-2000, 12:06 PM
create a new query and put the syntax that I gave you in a new field eg: New fieldName: [Field1]&[Field]&[Field3]. I hope this helps