Wrong Address Pulling

Options
I'm trying to pull a report on donors within select cities.


I created the query using one of, and I plugged in the cities, and for the most part got the info I wanted EXCEPT it pulled in a donor who I know USE to live in one of the select cities, but no LONGER lives in that city.


I looked at the donor's address on Bio 1 tab and it lists the new city (not the select).  I looked at Addresses and the preferred address is the new city (again not the select), yet she keeps being pulled in to the report.  In my query I even asked that preferred address line 1 be pulled in (along with preferred city and state, etc.).


So, my question is what can I do to ensure I have accurate data?  Is there another field I should be selecting?  Or . . . and I don't see this, but I'm wondering . . . if the donations were done under the old address is that why they're being pulled into my report?


The output is:

Name

GL Post Date

Gift ID

Preferred Address 1

Preferred City State

Preferred ZIP

Email - Preferred Number

 

Comments

  • Are you also using the preferred address in the criteria, as well as the output? The output fields don't affect which constituents are included, only what information about them is displayed in the results.
  • you can also include Preferred Address Send Mail = Yes. and/or Is Address Valid? = No (which actually means yes) to force the issue.
  • That was the solution = to plug that info in the criteria!

Categories