J
JimO
I have two fields:1 # (numeric), & Street (text). How can I combine them
into a new field, Address?
into a new field, Address?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
JimO said: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
A
Allan Murphy
Try House_address = [house_number] & " " & [street]
Where house_number is the numeric number of the house.
Allan
Where house_number is the numeric number of the house.
Allan
J
JimO
Thank you Allen!
Allen Browne said:JimO said: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
J
JimO
Thank you Allan!
Allan Murphy said:Try House_address = [house_number] & " " & [street]
Where house_number is the numeric number of the house.
Allan
JimO said:I have two fields:1 # (numeric), & Street (text). How can I combine them
into a new field, Address?