Welcome to Forums Sign in | Join | Help | Forums
in Search


Inaccurate Data Being Pulled in Query

Last post 08-06-2009 12:16 PM by Leslie Heisler. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-06-2009 11:53 AM

    • Rose Orr
    • Top 150 Contributor
    • User Since: 2007
    • Posts 65
    • Organization: Community Living London
    • Products:  The Raiser's Edge

    Inaccurate Data Being Pulled in Query

    I am trying to get a list of active volunteers for a particular program.   In my query I have "volunteer type status = active" and then parameters more specific to the program.  My problem is that, despite asking for only active volunteers, I am getting all the inactive ones as well.  Can anyone tell me why this is happening?

    Yours Truly,
    Rose Orr
    Database Administrator/Software Support
    Community Living London
    190 Adelaide St. S. London, Ontario N5Z 3L1
    Phone: (519) 686-3000 ext. 382
    Filed under: ,
  • 08-06-2009 12:16 PM In reply to

    • Leslie Heisler
    • Top 75 Contributor
    • User Since: 2002
    • Posts 114
    • Organization: Southwestern Vermont Health Care
    • Products:  The Raiser's Edge, The Researcher's Edge

    Re: Inaccurate Data Being Pulled in Query

    Are you using an AND operator between volunteer type status and paramater?  If you query on volunteer type status = active OR paramater = x you'll get inactive volunteers who meet the conditions of the parameter.  Similarly, if you have more than one paramater your query should look like this:

    volunteer type status = active AND (parameter a = x OR parameter b = x OR parameter c = x)

    Leslie

    Leslie Heisler
    Southwestern Vermont Health Care
    www.svhealthcare.org
Page 1 of 1 (2 items)