Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Events Management DB - Please Help !

Discussion in 'Information Technology' started by marknv@gmail.com, Nov 4, 2005.

  1. marknv@gmail.com

    Expand Collapse

    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.
    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 !?!
  2. Loading...

    Similar Threads Forum Date
    United Sikhs UNITED SIKHS Launches Olympics Langgar Pre-Events Sikh Organisations Jun 11, 2012
    United Sikhs Human Rights Messages Transcend The Physical Boundaries Of The Places & Events They Depict In Films Sikh Organisations Sep 1, 2011
    SALDEF Outreach Events Empower Sikhs Of Atlanta Sikh Organisations Aug 20, 2011
    Ashamed To Be Indian: After Recent Events In Uttar Pradesh Hard Talk Jul 20, 2011
    Sikh Community Promotes Awareness About Organ Donation At Diwali Events Community Out-Reach Nov 2, 2010

  3. OP
    Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

    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

    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page