Look up value in two different queries

[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.

 

[John Viescas]

A UNION query might solve your problem, but it's hard to guess without
knowing the actual business problem you're trying to solve and the structure
of the two tables.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411

 

[Jeff Boyce]

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>

 

[Cherly]

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

 

[Jeff Boyce]

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>