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.
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.