Microsoft access: Report and data in the report

Occasional Visitor

I am trying to create an invoice report. Everything works perfectly accept the invoiced items are duplicated based on the number of items for that group.

Thus, I have grouped the report based on a order no.  The report returns the orders fir that number. However, it duplicates the invoiced items based on the number of items for that order no group. Thus if in the order three items are invoiced it will report the three items three times  so I get three perfectly listed items but duplicated three times.

The query I run outside of the report is perfect with no duplicates. Even the subform I created which is used in the report reflects perfectly outside of the report. That is  only shows one set of grouped items. However, when run in the report the duplicating appears.

I would live to know how to solve this.

0 Replies