S
Shawn Johnson
I'm a novice at using Access so hopefully someone here can help
I have two tables:
Table 1 consists of verified customer addresses without any personal
customer info. (things like civic#, streetname, and community)
Table 2 consists of customers that have been manually inputed but may not
have necessarily given there civic address properly. (they may not have
given the correct civic# , streetmane)
What I am trying to do is create a report that will be based on the verified
information but also has the added customer names when possible. One of the
problems is that in the first table you will have a streetname called ABNEY
RD and in the other table you may have a streetname called ABNEY with
perhaps the RD in another field or perhaps no RD at all. How do I make a
query that will ignore the street type completely and just match up ABNEY
with ABNEY?
Thanks
I have two tables:
Table 1 consists of verified customer addresses without any personal
customer info. (things like civic#, streetname, and community)
Table 2 consists of customers that have been manually inputed but may not
have necessarily given there civic address properly. (they may not have
given the correct civic# , streetmane)
What I am trying to do is create a report that will be based on the verified
information but also has the added customer names when possible. One of the
problems is that in the first table you will have a streetname called ABNEY
RD and in the other table you may have a streetname called ABNEY with
perhaps the RD in another field or perhaps no RD at all. How do I make a
query that will ignore the street type completely and just match up ABNEY
with ABNEY?
Thanks