Query gives wrong output

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
 
G

Gary Walter

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