join 2 fields in the same table

[Guest]

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

don't know how to do that

THanks

Kevin

 

[Guest]

Address: [street number] & " " & [street name]

 

[Guest]

where do i put that statement? a union statement in sql or what?

Address: [street number] & " " & [street name]

--
KARL DEWEY
Build a little - Test a little

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

don't know how to do that

THanks

Kevin

 

[Guest]

Open you query in design view and add it to the grid in the FIELD row.
--
KARL DEWEY
Build a little - Test a little

where do i put that statement? a union statement in sql or what?

Address: [street number] & " " & [street name]

--
KARL DEWEY
Build a little - Test a little

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

don't know how to do that

THanks

Kevin

 

[John W. Vinson]

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

Why?

In my opinion you're much better off keeping them separate. It's dead easy to
combine them for display purposes; create a Query selecting all the other
fields that you want to see and in a vacant Field cell type

FullAddress: [Street_Number] & " " & [Street_Name]

This field can be used as the control source for a textbox on a form or
report, it can be exported, etc. You can still sort or seach by street name
independently; if you run an Update query combining the fields it will be a
good bit harder to do so.

John W. Vinson [MVP]

 

[Guest]

Well when I put is there it asks for a street name then street number. i
just want it to join all 250,000 records into on field. I must be missing
something?

Kevin

Address: [street number] & " " & [street name]

--
KARL DEWEY
Build a little - Test a little

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

don't know how to do that

THanks

Kevin

 

[Guest]

Well the main table has a the address in full form and I am trying to match
it with this other so I can get rid of dupes. when they are seperate they
aren't. Make sense?

Kevin

I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

Why?

In my opinion you're much better off keeping them separate. It's dead easy to
combine them for display purposes; create a Query selecting all the other
fields that you want to see and in a vacant Field cell type

FullAddress: [Street_Number] & " " & [Street_Name]

This field can be used as the control source for a textbox on a form or
report, it can be exported, etc. You can still sort or seach by street name
independently; if you run an Update query combining the fields it will be a
good bit harder to do so.

John W. Vinson [MVP]

 

[John W. Vinson]

Well the main table has a the address in full form and I am trying to match
it with this other so I can get rid of dupes. when they are seperate they
aren't. Make sense?

Kevin

Kevin, you can see your database; you know what you are trying to figure out.
We don't. All we can see is what you post. In your original message you said

============
I have a pretty large table (251000 records) and 2 of the fields:

street number
street name

are 2 fields i need to combine into this same table so that it reads:

123 main st in one field instead of:

123 in street_number and
main st in street_name

=============

Now it seems that you have a - different! - "main table" and "the other".

We don't know what the main table, or the other, might be; and we don't know
what you're trying to accomplish, unless you tell us.

Give us a hand here, please?


John W. Vinson [MVP]