Query-Who moved within the past year?

0 votes
245 views
asked May 15, 2018 in How To by Mrs. Stendig
what would the query criteria be in order to see which accounts had an address change within the past year?

 

thank you
commented May 15, 2018 by YakovKantor
You want to see who's address changed in the past year?
commented May 15, 2018 by Mrs. Stendig
yes, thank you
commented May 15, 2018 by YakovKantor
Can you call in?

1 Answer

answered May 16, 2018 by yczehn
selected May 16, 2018 by Mrs. Stendig
 
Best answer
The best way is when someone moves instead of deleting the address you change the address type to old home, like that you can query old home and when it comes to match addresses with gov data many times they only have the old address on file, technically you can also query the history for all address changes it will give you all changes including form "st" to "Street" or "ct" to "ct." which is not what you're looking for
commented May 16, 2018 by Mrs. Stendig
thank you,

I did want to add though that for the purposes i needed this for, it will be helpful to get a list based on history query. How do i go about that?
commented May 16, 2018 by yczehn
Generic > Mhistory, DateChanged Select dates from to, GridName select DBGrid_Address.
commented May 16, 2018 by Mrs. Stendig
where is GridName select DBGrid_Address?

Let's Welcome our New Members

...