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

[JimO]

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

 

[Allen Browne]

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

 

[Allan Murphy]

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

Allan

 

[JimO]

Thank you Allen!

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

 

[JimO]

Thank you Allan!

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

Allan

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