Duplicate Fields

[RobW]

When I query a query and include fields from a table, the fields duplicate. I sorted this by selecting the join type as "only include rows where the joined fields from both tables are equal". I have two tables and two queries that I want to create a query about. The joins come via the field FirstName. Is there a join type I should create? Any one help?

 

[sonny]

When I query a query and include fields from a table, the fields duplicate. I sorted this by selecting the join type as "only include rows where the joined fields from both tables are equal". I have two tables and two queries that I want to create a query about. The joins come via the field FirstName. Is there a join type I should create? Any one help?

post your sql statement here for a look...

 

[RobW]

SELECT tblMembers.MemberNumber, tblMembers.FirstName, qry1QtyDNB.QtyDNB2, qry1QtyNotOut.QtyNotOuts
FROM qry1QtyDNB, qry1QtyNotOut, tblMembers INNER JOIN tblScoreCard ON tblMembers.MemberNumber = tblScoreCard.MemberNumber;