repeated entries in report

[harps]

i have built a report on top of a query. the query is on customer orders with the criteria "customer no". when i run the query the results are fine, but when i run the report based on it, it repeats al the listings several times. is it the way the report is formed or something else?.

I have also accidently posted this in "forms", so if someone could remove it please........

harps

 

[HGMonaro]

1st re-check your query, the report will usually only show what the query is selecting. Sounds like your query is creating the duplicates, you might have duplicate data in the tables.