Look up value in two different queries

  • Thread starter Thread starter Cherly
  • Start date Start date
C

Cherly

Does Access have the capability of looking up values in
two different queries? field A in query one has a
different name than field b in query two.
 
Cherly

If the two queries have a common, related field, you can join them just like
you would join two tables in a query design grid. If they don't have a
common field, how are you proposing to relate them?

Good luck

Jeff Boyce
<Access MVP>
 
I probably should have been more specific... what I have
are two queries (very large that we can not put in excel)
both queries list debtors and their account numbers. What
we want are account numbers and names of debtors that are
listed in both queries... their name may be listed in both
queries but have different account numbers that are in
arrears. CC
 
So, you are ABSOLUTELY certain that the names are spelled IDENTICALLY in
both lists? (hint: if you answer "yes", you might be in for a shock)

Resolving "duplicates" like the two lists you have can be problematic,
especially when you don't have any guaranteed "linking" field ("but have
different account numbers..."). Is there any common field, other than name?

(here's an example of why this is a problem -- are the following all the
same person?)

John Smith
J. Smith
John J. Smith
J. J. Smith
"Bud" Smith

(and how could you tell?!)

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top