querying things in history tab

0 votes
138 views
asked Jul 23, 2015 in Reports by mbs
If I want to see all Parents' whose address was changed from a certain date to a certain date, can I run such a Query? (i want to know whose address I need to change in the NPSIS system, let's say)

1 Answer

answered Jul 28, 2015 by Admin
selected Aug 4, 2016 by mbs
 
Best answer
If you want to query for a list of accounts that have a changed address you can use the Generic tab to query the MHistory Table. But if you want to get a list of addresses you would need to get a report that shows a list of addresses and have the query built in to the report.
commented Aug 3, 2016 by mbs
If I don't change an address, instead i change it to "Old Home" and put the new address by "Home" can I still query by date whose address was changed?
commented Aug 3, 2016 by Admin
Was. Look for dateentered.
commented Aug 3, 2016 by mbs
i don't see it in the choose field when i select MHistory.
commented Aug 3, 2016 by Admin
Its in maddress.

Let's Welcome our New Members

  • 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

  • samual of Satmar Bloomingburg - Mar 07, 2024

  • lrottenberg of Yeshiva S. Fallsburg - Mar 07, 2024

  • roth of Mareh Yechezkal - Mar 06, 2024

  • lev of UTA BP - Mar 05, 2024

...