CONCATENATE

[dadesiboy]

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]

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]

The ampersand is the concatenation function
[field1]&[field2]&[field3]=field1field2field3

 

[dadesiboy]

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]

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