Query gives wrong output

  • Thread starter Thread starter RFJ
  • Start date Start date
R

RFJ

T1 is a table that contains customer details (one record per customer)
T2 is a table that contains contains customer orders (multiple records per
customer)
Q1 is a query that merges some of the information in T1 and T2 via selection
criteria to produce a subset.

So far so good.

I'm now trying to create another query, Q2, to report any customers in Q1
that satisfy additional criteria.

However, when I run the query, rather than get one line of information from
each customer that satisfies Q2 criteria (the answer I want), I get as many
as lines of information as there are records for that customer in T2.

Can SKS tell me how to overcome it.

TIA

Rob
 
Does this mean you don't want
help from "Some Kind Ms,"
of which there are many competent
helpers on this ng.?
 
Back
Top