Events Management DB - Please Help !?!

[marknv]

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 !?!

 

[Albert D.Kallal]

Simply build a report, and have that report NOT show those titles. Get the
report working the way you want.

A super duper simple report can just list the peoples names, phone numbers
etc. Get it working, and get it to NOT show duplicates.

(don't use a sql join to bring in the extra titles, in fact remove the sql
joins to display the names).

Now, build a very little report based on a query that lists the

Person_id title


Now, use the wizard and simply drop in this tiny little report into he
detail line of the report. Each person will continue to only be shown
once.....