Query not pulling only country I requested

Options
Beverly Lyles
Beverly Lyles ✭
Ancient Membership Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussion

I am having problems with my query pulling more than just the country I am requesting.  I ask for country to equal United States but it pulls many other countries as well as US.  Is this a glitch or is there something special I need to do to make it stop giving me China, Japan, Mexico, Canada, etc. when I want just US addresses?

Tagged:

Comments

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic
    Bev Lyles:

    I am having problems with my query pulling more than just the country I am requesting.  I ask for country to equal United States but it pulls many other countries as well as US.  Is this a glitch or is there something special I need to do to make it stop giving me China, Japan, Mexico, Canada, etc. when I want just US addresses?

    Bit hard to guess what is causing it to pull others without seeing, but some thoughts...

    Assuming you have other criteria, are you using an "OR" somewhere in criteria list?  You may need to use "(   )" and to check for "AND"

    Are you just having it query on 'primary' address?  Do these records have more than one address where it could be filtering on say China as a former/seasonal/etc address?  Is the US address always the first listed address or a particular address type that you could use as criteria?

    If that doesn't get anywhere, you may want to try negative of "Country not one of ...."  - not the preferred method for query but may help.

  • Joshua Bekerman bCLO bCRE
    Joshua Bekerman bCLO bCRE ✭
    Tenth Anniversary Facilitator 3 Name Dropper Photogenic
    Bev Lyles:

    I am having problems with my query pulling more than just the country I am requesting.  I ask for country to equal United States but it pulls many other countries as well as US.  Is this a glitch or is there something special I need to do to make it stop giving me China, Japan, Mexico, Canada, etc. when I want just US addresses?

    Are you querying on All Addresses or Preferred Address, or Address Processing?  Then in your Export (or Query output fields) how are you pulling addresses?
  • Beverly Lyles
    Beverly Lyles ✭
    Ancient Membership Facilitator 1
    Josh Bekerman:
    Are you querying on All Addresses or Preferred Address, or Address Processing?  Then in your Export (or Query output fields) how are you pulling addresses?
    Thanks everyone. Your help made me look at my query a little bit differently. The one query that I had problems with didn't have any "or" in it but when I moved the "country" to the first line of my query it seemed to take care of the problem. Don't know why that would make a difference but it did and it worked. The other query I had problems with did have an "or" but, again, when I moved the "country" to the first line of my query it took care of it also. Thanks to all of you for your help.

Categories