Help with combining fields

[viper]

I have a database that consists of 1 table with contact details that we have bought from a market research company, in the table there is separate fields for Title, first name and surname how can I combine them into 1 field, as I need to export all of the details to a CSV and need the full name in 1 field.

Thanks peeps

 

[GeoByte]

Hi Viper,
Just make a query and add an expression as the fieldsource like
Fieldmerge: [Field1] & " " & [field2]
Goodluck!

 

[aflack]

SELECT [FIRSTNAME_FIELD] & " " & [SIRNAME_FIELD] AS FULLNAME
FROM TABLE_NAME_HERE;

You can use the & to concatinate fields, alter the above and save it as a query.

Hope this helps and i answered your question.

(too slow answering ans someone beat me to it )

 

[viper]

Thanks for the Quick response

I have used the following

FULLNAME: [Title] & " " & [Firstname] & " " & [Lastname]

That is all working fine now, but when I include the full name QRY within another QRY it is displaying the same full name all the way down the results, how can I link the full name to the corresponding records.

Thanks

 

[aflack]

you have not set your table Joins correctly in the query i think.

best way to do this in access is find the linking fields that match in the tables and drag one onto the other in the query builder.

Andy.

 

[viper]

Cheers linked it to the Record ID and all working now