combine valu es from 2 fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JN - 16 Jul 2006 21:17 GMT

Hi.
I would like to combine the field values from Address 1 with those of
Address 2.
I am familiar with queries but not exactly sure how to go about this.
Can anyone please tell me how.
JB

Reply to this Message

Rick Brandt - 16 Jul 2006 21:41 GMT

> Hi.
> I would like to combine the field values from Address 1 with those of
> Address 2.
> I am familiar with queries but not exactly sure how to go about this.
> Can anyone please tell me how.
> JB

Add a new column in the query designer...

Address: [Address 1] & " " & [Address 2]

(or if you prefer a line feed between them)...

Address: [Address 1] & Chr(13) & Chr(10) & [Address 2]

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

MGFoster - 16 Jul 2006 21:49 GMT

> Hi.
> I would like to combine the field values from Address 1 with those of
> Address 2.
> I am familiar with queries but not exactly sure how to go about this.
> Can anyone please tell me how.

SELECT Address1 & " " & Address2 AS Adrs
FROM Addresses

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

Reply to this Message

JB - 20 Jul 2006 17:06 GMT

Thank you

>> Hi.
>> I would like to combine the field values from Address 1 with those of
[quoted text clipped - 4 lines]
> SELECT Address1 & " " & Address2 AS Adrs
> FROM Addresses

Reply to this Message