Query results don't match the list or export

@Dana Burton
Query and Export differences in rows exported usually means 1 thing, in query, you are criteria-ing, outputing, or sorting by a 1-many field.

look in query in the 3 tabs and see if there's anything there that is a 1-many relationship (i.e. 1 gift having multiple soft creidt, multiple campaign/fund/appeal/package, multiple gift solicitor, multiple attribute, etc)

@Dana Burton
You are hitting problem that we are talking about: 1 to many relationship not handled properly.

• Email Number not blank will give you 1 row for every email address a constituent record has that's not blank, which in itself is already producing multiple rows for each constituent record.
• Solicit Code is also a 1-many relationship, as a constituent can have multiple solicit code, so this will further mulitple # of record rows produced.

While I don't know your query intention on the Solicit Code, but it looks like it may be wrong

Note that:

A and B and C or D

is not the same as

A and B and (C or D)

You may need to use some paranthesis or simply just do 1 Solicit Code filter and not 2. Use either one-of or not-one-of operation and select the ones you want/don't want.

Query can be more powerful than Export when you are very aware of what can be 1-many relationship and filter/output accordingly and dedup in Excel consciously knowing what you looking for to dedup your list. If you are not strong with Query, I recommend you use Query for filtering ONLY and use Export to output the info you want.

@Dana Burton, while the others have addressed the parenthetical grouping – A and B or C vs. A and (C or – allow me to add more context. In your list below:

This OR at the bottom in essence cancels out all your other criteria. All a record has to have is a solicit code “Email Only” and it will pull whether it is marked primary, inactive, etc or not.

Also, I question whether these criteria are really getting you what you want. Many of them are conflicting as written. You have “Phone is Primary” AND “Phone Not Inactive”, which seems redundant since a phone should not be marked as both in a clean database. The “Phone not inactive” filter will exclude anyone with a cellphone or landline marked Inactive, even if they have a viable email address. Also, you included “Deceased equals No”, when that is already a checkbox option at the top of your query.

I don't know the goal of your list, but just throwing it out there, I'd propose the following process. This will get you a list of people with active, solicitable emails.

Pull a broad query. The query is unable to filter as precisely as you are trying to do.

Then, include certain output fields in your export:

Some lines of your export may be blank in the Email column if the donor only has an Inactive email type. Sort these out and remove any blanks, to get your final list. I strongly suggest keeping your email types clean and having a specific email type for active emails, to minimize this issue.