how to combine 2 fields: i.e. (house# + street)=(new)address

's Computer Specifications

I have two fields:1 # (numeric), & Street (text). How can I combine them
into a new field, Address?

's Computer Specifications

"JimO" <(E-Mail Removed)> wrote in message
news:E3D07B23-23DE-4D3C-A60A-(E-Mail Removed)...
> I have two fields:1 # (numeric), & Street (text). How can I combine
> them into a new field, Address?

Create a query.

Type this into a fresh column in the Field row:
FullAddress: Trim([F1] & " " & [F2])
substituting your field names for F1 and F2.

You should not store this into a new field in your table, unless there could
be valid reasons why the full address should *not* be the same as the
concatenation of the 2 fields. If you do need to so this, use an Update
query (Update on Query menu) to update the Address field to the expression
above.

More info in:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

's Computer Specifications

Try House_address = [house_number] & " " & [street]
Where house_number is the numeric number of the house.

Allan

"JimO" <(E-Mail Removed)> wrote in message
news:E3D07B23-23DE-4D3C-A60A-(E-Mail Removed)...
>I have two fields:1 # (numeric), & Street (text). How can I combine them
> into a new field, Address?

's Computer Specifications

Thank you Allen!

"Allen Browne" wrote:

> "JimO" <(E-Mail Removed)> wrote in message
> news:E3D07B23-23DE-4D3C-A60A-(E-Mail Removed)...
> > I have two fields:1 # (numeric), & Street (text). How can I combine
> > them into a new field, Address?
>
> Create a query.
>
> Type this into a fresh column in the Field row:
> FullAddress: Trim([F1] & " " & [F2])
> substituting your field names for F1 and F2.
>
> You should not store this into a new field in your table, unless there could
> be valid reasons why the full address should *not* be the same as the
> concatenation of the 2 fields. If you do need to so this, use an Update
> query (Update on Query menu) to update the Address field to the expression
> above.
>
> More info in:
> Calculated fields
> at:
> http://allenbrowne.com/casu-14.html
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>

's Computer Specifications

Thank you Allan!
"Allan Murphy" wrote:

>
> Try House_address = [house_number] & " " & [street]
> Where house_number is the numeric number of the house.
>
> Allan
>
> "JimO" <(E-Mail Removed)> wrote in message
> news:E3D07B23-23DE-4D3C-A60A-(E-Mail Removed)...
> >I have two fields:1 # (numeric), & Street (text). How can I combine them
> > into a new field, Address?
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to House, 123 Street, Somewhere, M1 23X	Nick C	Microsoft Excel Misc	1	23rd Jul 2008 03:31 PM
parsing address into house #, Street name, street type	upstate-dem	Microsoft Access Queries	3	2nd Feb 2007 06:31 AM
Need to combine people at same street address	spam4jordan@gmail.com	Microsoft Excel Programming	0	5th Dec 2006 09:20 PM
How do I split out the House # from the Street name - for Sorting	=?Utf-8?B?QWx5Y2U=?=	Microsoft Outlook Contacts	0	18th Aug 2005 03:39 AM
Separate Out House Number From Street Address	=?Utf-8?B?U2FuZHk=?=	Microsoft Access Form Coding	4	9th Jun 2004 02:36 PM