duplicate records on query and report

  • Thread starter Thread starter Ande
  • Start date Start date
A

Ande

I have a query that sits underneath and invoice report.
This query is duplicating each line item on every single
invoice that I generate and I don't know why. I can hide
the duplicates on the report properties but some of my
customized tax calculations are based on summing the line
items so this does not work. i need to find out what I
am doing wrong that would solve the duplication of each
line item.
Thanks
 
Hi,


You may have a join on a table an one of the field involved in the ON
clause has duplicated values. That would double (triple is the duplication
is triple, etc) the occurrence of the values (the matching records) from
the other table involved in the join.

If you can't remove the duplicated value, try to add a DISTINCT in the
SELECT clause:

SELECT DISTINCT ...




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top