I am pulling together a report, and it is a list of people who attended events. When I make the query everything seems to be running just fine, except i get duplicate names of people who have been to multiple events. Is there any way i can set it up, I need to see all the people who have and have not been at events (a check box in the report denotes if they have or have not) can i make it so that if they have been to at least one event they get the check without listing their name for the times they have not?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
no need for duplicates
- Thread starter czarjosh
- Start date
Could you group by the names in the report instead of putting their names in the detail section?
Dawn
Dawn
- Status
Similar threads
- Locked
- Question
- Locked
- Question