Hi all,

We need to go back and update a group of constituent records that have been added over the last few months by a single user.  Since there is no audit trail for constituent records (is there?), we were hoping to be able to use "Constituent ID" as a way to narrow it down significantly.

I can find a way in Advanced Query (Constituents/Constituent Geography/Constituent ID) to get a "greater than" group of records that corrals everything entered past a certain ID Number but we're kind of having to throw a dart at what that starting number is.

I'm wondering if anyone out there has found more sophisticated ways to use Constituent ID for this kind of search? And/or to get a group of Constituent records to sort by Constituent ID instead of alphabetically?

We're in TMS 2012 at the moment, upgrading shortly to 2014

Thanks very much

Margaret Bullock

TAM celebrating 80 years

Margaret Bullock
Curator of Collections and Special Exhibitions

T: 253-272-4258 x3019
1701 Pacific Avenue, Tacoma, Washington 98402
www.TacomaArtMuseum.org<http://www.TacomaArtMuseum.org>

[ArtAIDSAmerica_TAM_320x50]<http://www.tacomaartmuseum.org/AAA>

               SUPPORT<http://www.tacomaartmuseum.org/support/membership/> | SHARE<http://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fwww.indiegogo.com%2Fprojects%2Fart-aids-america%23%2F> | GIVE<https://www.indiegogo.com/projects/art-aids-america#/>


To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.