full name vs first and last name

G

Guest

I have two tables. One has "customer full name" in one field. The other is
from another database and has two fields, : "first name" and "last name". I
want to retrieve all records that match :customer full name" in one table
with "first and last name" in other table. I don't know how to do it. Or
Better suggestions? Thanks you very much in advance.
 
P

PC Datasheet

Create a query based on your second table. In a blank field in the query
type this expression:
FullName:[First Name] & " " & [Last name]
Create a second query that includes the above query and your first table.
Join "Customer Full Name" to "FullName". This second query will return all
records where the full name is the same in both tables.
 
G

Guest

Jay,

Create a query based on your table with seperate names add a calculated
field like "fullname:[firstname]&" "&[lastname]" without the quotes. This
query will now return a fullname field which can be joined to your other
table. NOTE: Any differences in name spelling such as Robert Jones and Bob
Jones will not match.

Terry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top