Re: combine valu es from 2 fields

From: "Rick Brandt" <rickbrandt2@xxxxxxxxxxx>
Date: Sun, 16 Jul 2006 20:41:48 GMT

JN wrote:

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]

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

.

References:
- combine valu es from 2 fields
  - From: JN

Prev by Date: Re: my employee listing
Next by Date: Re: Database Search with string portion
Previous by thread: combine valu es from 2 fields
Next by thread: Re: combine valu es from 2 fields
Index(es):
- Date
- Thread

Relevant Pages

Re: DateAdd Function
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(microsoft.public.access.forms)
Re: Force a save
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(microsoft.public.access.modulesdaovba)
Re: Combo Box Wizard Options
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(comp.databases.ms-access)
Re: How to continuously append live table to table?
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(comp.databases.ms-access)
Re: Report Filter????
... Rick Brandt, Microsoft Access MVP ... RBrandt at Hunter dot com ...
(microsoft.public.access.reports)