Finding data in 2 tables

[jtlawn]

I need to be able to search 2 tables to see if a client exists. I will probably have to do the search either by last name or phone number, and the field names are different, and it is possible to multiple matches in both tables. If I join 2 tables in a query, is it true that I will only get the matches from 2 tables? If I change the join line to bring all data from one table or another will it look for matches in all fields or just the linked field? Is there code I can write that is easier and more effecient?

Thanks

Joe Lawn
joe_lawn@cardinalbuilders.com

 

[cottontop]

Join the two by lastname.

In a query list lastname from both tables. In one of the lastname's criteria, place "not is null". That will show all the exact matches.

Place "is null" to show where they don't match.

 

[jtlawn]

Thank You,

I will give it a try and get back with on how it works.

Joe Lawn
joe_lawn@cardinalbuilders.com