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

 

[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