Welcome to SPN

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

Sign Up Now!

Why does Access make mistakes when counting?

Discussion in 'Information Technology' started by Richard, Jul 28, 2006.

  1. Richard

    Richard
    Expand Collapse
    Guest

    I am running a query in which I am asking Access to count the number of
    events linked to individuals in a particular month.

    Each individual and crime has a unique number. The query is based on three
    tables linked together: the details of the people, the details of the crimes
    and the links between them.

    When I ask the file to count the number of events for a particular
    individual, it tells me that there are 23. When I change the command to
    "Group By" to list the events with their particular identification numbers,
    there are 11. Having run other checks, it is clear that 11 is the correct
    number. The same thing has happened for other individuals and is the same
    with unique value and unique records set to yes. I cannot see any
    predictable relationship between the right and wrong numbers.

    Why is Access counting wrong?
     
  2. Loading...

    Similar Threads Forum Date
    Buddhism Why Does Buddha Have A Jooda? Interfaith Dialogues Nov 29, 2014
    General Why does Caste still Persist with Sikhs? Hard Talk Jul 31, 2012
    General Why Does SPN Publish Third-Party Advertisement? Hard Talk Jul 15, 2011
    Why Interfaith Dialogue Doesn't Work - What We Can Do About It Interfaith Dialogues May 30, 2011
    Confucianism Who was Confucious and Why Does it Matter? Interfaith Dialogues May 23, 2011

  3. ChrisM

    ChrisM
    Expand Collapse
    Guest

    Hi Richard,

    Would you like to show us the queries that you are running, and an example
    of the data that is giving these results?
    My guess is that in linking the tables, you are not linking unique keys
    correctly, and aregenerating more rows than you should have.

    Cheers,

    Chris.


    "Richard" <Richard@discussions.microsoft.com> wrote in message
    news:60B57F46-FC67-4A15-AA34-DA882B4E78CB@microsoft.com...
    >I am running a query in which I am asking Access to count the number of
    > events linked to individuals in a particular month.
    >
    > Each individual and crime has a unique number. The query is based on
    > three
    > tables linked together: the details of the people, the details of the
    > crimes
    > and the links between them.
    >
    > When I ask the file to count the number of events for a particular
    > individual, it tells me that there are 23. When I change the command to
    > "Group By" to list the events with their particular identification
    > numbers,
    > there are 11. Having run other checks, it is clear that 11 is the correct
    > number. The same thing has happened for other individuals and is the same
    > with unique value and unique records set to yes. I cannot see any
    > predictable relationship between the right and wrong numbers.
    >
    > Why is Access counting wrong?
     
  4. Richard

    Richard
    Expand Collapse
    Guest

    Its OK I have now worked out where the problem is!
     
  5. ChrisM

    ChrisM
    Expand Collapse
    Guest

    Out of interest, what was it?

    "Richard" <Richard@discussions.microsoft.com> wrote in message
    news:6336AEBC-6A7F-4BD1-968A-E3F365876D95@microsoft.com...
    > Its OK I have now worked out where the problem is!
     

Share This Page