Creating a query that will merge various fields into one field

[ChrisSedgwick]

Hi,

I'm looking for a way to merge various fields from a table into just one using a query.

The purpose will be for easier copying and pasting in to an email.

So we have a table to stores information such as Site Contact, Address 1, Address 2, Address 3, Postcode etc.

I want to be able to run a query that will put the address in to just one box, either in the query or on a report then it's much easier to just highlight the full address and copy and paste it into an email. Rather than copying each field individually.

Is this possible, if so, how?

Many thanks,
Chris.

 

[pr2-eugin]

Create a SELECT Query that will get you this information. Something like,

SELECT
    addressLine1 & " " & addressLine2 & " " & addressLine3 & " " & postCode As fullAddress
FROM
    yourTabelName

 

[ChrisSedgwick]

Thanks Paul, done the trick perfectly!

 

[pr2-eugin]

Most Welcome. Good Luck