Remove duplicate records in query based on 2 tables.

J

JoanOC

I have an invoice query based on an invoice table.
I want to add one field from another table in the query, but when I do the
query runs duplicate records. There is a primary key in both that are joined.
 
J

Jamie Richards

You can solve duplicate issues by using the GROUP BY clause. What you have
to be careful of is exactly how you group your records. Make sure
 
Top