How to add cell 3(house #) to cell 4(Street name) in Db of 170,00.

[Guest]

I have a Db of 170,000 adresses. The house # is in cell 3, the street name is
in cell 4. How do I merge these two?

 

[John Vinson]

I have a Db of 170,000 adresses. The house # is in cell 3, the street name is
in cell 4. How do I merge these two?

Is this an Access database, or an Excel "database"? It's quite
possible in either case, but you're posting in an Access newsgroup and
referring to "cells" with cell numbers, which sounds like Excel rather
than Access.

If it is in Access, and you have fields named [3] and [4] (unwisely
IMHO), you can create a Query with a calculated field:

Address: [3] & " " & [4]

John W. Vinson[MVP]

 

[Joseph Meehan]

I have a Db of 170,000 adresses. The house # is in cell 3, the street
name is in cell 4. How do I merge these two?

In a database you really don't want to merge them. You use a query to
concatenate them.

StreetAddress: [cell 3] & " " & [cell 4]

If you were to really merge them, then you could no longer sort by
street name which you may find very useful next week.