Creating a query that will merge various fields into one field

ChrisSedgwick

Registered User.
Local time
Today, 12:16
Joined
Jan 8, 2015
Messages
119
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.
 
Create a SELECT Query that will get you this information. Something like,
Code:
SELECT
    addressLine1 & " " & addressLine2 & " " & addressLine3 & " " & postCode As fullAddress
FROM
    yourTabelName
 
Thanks Paul, done the trick perfectly! :D
 

Users who are viewing this thread

Back
Top Bottom