combine valu es from 2 fields

  • Thread starter Thread starter JN
  • Start date Start date
J

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
 
JN said:
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
Click to expand...

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]
 
JN said:
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.
Click to expand...

SELECT Address1 & " " & Address2 AS Adrs
FROM Addresses
 
Back
Top