Query-Who moved within the past year?

0 votes
143 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

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...