We are also on 2012, and we do not have "Is Current" available in the Hierarchy either. We have updated the service pack yet. -Suzanne Stephens, Birmingham Museum of Art From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Frances Francis Sent: Monday, October 28, 2013 3:22 PM To: [log in to unmask] Subject: Re: Current Value Query Michelle - we encounter the same inaccurate query results as you described earlier, and "Is Current" does NOT appear in our Object Value hierarchy. We are running TMS 2012 . There's probably more like us out there... Frances Frances R. Francis | Senior Registrar High Museum of Art | 1280 Peachtree Street, NE | Atlanta, GA 30309 tel: 404.733.4480 | fax: 404.733.4502 | [log in to unmask]<mailto:[log in to unmask]> From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, October 28, 2013 3:22 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Current Value Query [cid:image001.png@01CED3FB.CC3A2DE0] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA Sent: Monday, October 28, 2013 12:05 PM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Current Value Query I've searched all over the data configuration to add 'is current' to my query options but I can't find it. Any clues under which hierarchy it is located? Thanks, Michelle Michelle Gallagher Roberts Chief Registrar New Mexico Museum of Art 505.476.5066 505.476.5076 fax From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, October 28, 2013 10:46 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Current Value Query Here's the query: [cid:image002.jpg@01CED3FB.CC3A2DE0] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA Sent: Monday, October 28, 2013 11:00 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Current Value Query I'm running TMS 2010 but I'm not trying to run a report just the query. Thanks, Michelle Michelle Gallagher Roberts Chief Registrar New Mexico Museum of Art 505.476.5066 505.476.5076 fax From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Christine Droll Sent: Monday, October 28, 2013 9:44 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Re: Current Value Query If you are running TMS2012 (maybe even TMS2010?), there is a Gallery System Crystal Report OB.Valuation Latest (assuming the current is the lastest) that will give you this information. There is also a tick box for current value (in TMS2012) that you can put into a report with the select expert, comme ça: [cid:image003.jpg@01CED3FB.CC3A2DE0] From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Roberts, Michelle, DCA Sent: Monday, October 28, 2013 10:30 AM To: [log in to unmask]<mailto:[log in to unmask]> Subject: Current Value Query I'm trying to query only the current value of objects but can't quite get what I want. I'd like to pull up every object which has a current value of over $100,000 (see below). This query is pulling every object which has ever had a value of $100,000 even if the most current value is less. Any ideas on how to solve this problem? [cid:image004.jpg@01CED3FB.CC3A2DE0] Thanks, Michelle Michelle Gallagher Roberts Chief Registrar 505.476.5066 505.476.5076 fax [cid:image005.jpg@01CED3FB.CC3A2DE0] It's About Time: 14,000 Years of Art in New Mexico Back in the Saddle - The horse as icon of the Southwest Georgia O'Keeffe - Selected Works Collecting Is Curiosity/Inquiry A Life in Pictures: Four Photography Collections 50 Works for 50 States: The Herbert & Dorothy Vogel Collection [cid:image006.jpg@01CED3FB.CC3A2DE0]<https://urldefense.proofpoint.com/v1/url?u=https://www.facebook.com/NewMexicoMuseumArt&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=wTtSrhG%2FvGKx5QHkZTn%2FQRhbhR7WYcOnxy2xGwFekDQ%3D%0A&s=47f3a81361b7f531274b9a3ff9742497c0b247fc5ed414797e2433f4f76a93d1>find us on facebook or check our website www.nmartmuseum.org<https://urldefense.proofpoint.com/v1/url?u=http://www.nmartmuseum.org/&k=diZKtJPqj4jWksRIF4bjkw%3D%3D%0A&r=XTJzpIcEHE%2Fdpcfy6DYLFGXNnGz7Bd9JKTihuOsgjts%3D%0A&m=wTtSrhG%2FvGKx5QHkZTn%2FQRhbhR7WYcOnxy2xGwFekDQ%3D%0A&s=d544c8d6fa7efaaf28da21a105b4146972dff4c5e7f7af223ea7297cb650d0a0> To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. To unsubscribe, send an email to [log in to unmask]<mailto:[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. 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.