Query on similar address fields

[bplantman]

I am new at Access, but I am trying to run a query on two tables where the linking field is the address field.

One table has addresses storred as "123 Elm Street #123" and the other stores them as "123 Elm St. Apt. 123"

Is there any way to run this query on these two tables with this difference in the address fields?

 

[neileg]

If the formats are always exactly as you describe, the you can use string functions to manipulate the data to produce a common format.

If you mean that the addresses are not consitent, and the formatting is up to whoever entered the data, you're not going to be able to do this programatically.

If the data is under your control, i.e. not a link to other systems, I'd think about using some 'search and replace' and some manual editing to cleanse the data.