Hello. I am working with an ACCESS 2002 DB. I am a newbie so I apologize in advance for any ignorance or sheer stupidity. I have a Database that manages Events. Here is my problem: My dilemma comes in the reporting. When I run a report, it shows 396 people attending an event. However there are actually only 382. But wait... The discrepancy is caused by Contacts having 2 or more entries. Example: Bob Smith - BA Bob Smith - MA Bob Smith - PhD I would like to count how many people are in attendance without duplicating contacts. But wait again... Here is the other monkey wrench which throws things off further: One person (e.g. Bob Smith) may get 2 invitations (i.e. if he wants to bring a guest) So if when the report erroneously says: Bob Smith - BA - Attending - 2 Bob Smith - MA - Attending - 2 Bob Smith - PhD - Attending - 2 The attending total should be 2 NOT 3 (as I've gotten using COUNT function) and NOT 6 (as I've gotten using the SUM function) The difficulty is that I must show Bob's degree information (whereby he may have many degrees - BA, MA, PhD) but limit his attending total to 2 ! I will also admit that I am a novice designer in regards to code as well. I have tried several codes and nothing really addressed this issue specifically. Is there anyone out there who can solve this !?!