Duplicate data in detail section

[TheLion]

I hope someone can help with this weird situation.

I have a report based on a query. The query has 8 fields in it. 6 of
these fields can have repeating data in them so I have put them in
header section. I would have assumed then that the number of records in
the detail section would match the number of records in the query, per
set of repeating data.

But, I get at least 2 detail records for each row in the repeating data
set, sometimes 3.

How is it that a report is showing more rows than there are in the
query?

Can anyone help please?

Thanks a million in advance.

 

[Jeff L]

From what you are describing, it sounds like you need to add some
grouping in your report. Simply putting fields in the header will not
eliminate duplicate values.

Hope that helps!

 

[TheLion]

Jeff

Thanks for responding.

There is grouping in the report. The only unusual thing about this
report is that the group header has several fields in it rather than
just one.

Lionel