combine valu es from 2 fields

[JN]

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

 

[Rick Brandt]

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]

 

[MGFoster]

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

 

[JB]

Thank you

SELECT Address1 & " " & Address2 AS Adrs
FROM Addresses