:confused: My database records entries to a horse show. Competitors may enter classes that run concurrently at the show. My query collects the entries in both classes, but the names appear twice so of course the report based on a query lists the entry twice. Can I write code or ???? so that the report for the class only lists that entry once?

Thanks in advance for any ideas any of you may have.

Sharon

:confused: My database records entries to a horse show. Competitors may enter classes that run concurrently at the show. My query collects the entries in both classes, but the names appear twice so of course the report based on a query lists the entry twice. Can I write code or ???? so that the report for the class only lists that entry once?

Thanks in advance for any ideas any of you may have.

Sharon

Hi sharon,


I thnk you need to group your data.

The query is grouped. I know - it sounds like that is all it would take, but not so,,

Any other suggestions.

Sharon

You should use a mainreport to display competitor data and you should use a subreport for the class data.

Add to sorting and grouping the group header of competitor
and in the detail - the class data