TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU
Options: Use Monospaced Font
Show HTML Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: Values
From:
"Badowski, Caitlin" <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Tue, 19 Aug 2014 14:01:29 +0000
Content-Type:
multipart/related
Parts/Attachments:
text/plain (67 kB) , text/html (8 kB) , image001.png (67 kB) , image002.jpg (67 kB) 
Hi Olga,

You should be able to find the 23 without attached values in an advanced query:
[cid:image001.png@01CFBB94.8BCDADA0]
Once you pull up the 23 objects, you could put a $0 value in, so at least they'll pull to your report.

Caitlin Badowski
TMS Administrator
Smithsonian National Postal Museum
2 Massachusetts Avenue NE, MRC 570
Washington, DC 20013-7012
(202) 633-8735
[log in to unmask]<mailto:[log in to unmask]>
[NPM Logo for Signature Block]

From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Zotova, Olga
Sent: Tuesday, August 19, 2014 9:58 AM
To: [log in to unmask]
Subject: Values

Dear TMS users,
I am just wondering how do you deal with objects that don't have values associated with them but you still want them to show up in your valuation report? For example I have a group of 180 objects when I go and run the 'valuation latest' report on them I get only 157. That is telling me that I don't have values for 23 objects, but which ones? Does anyone out there knows a way to fish out objects out of the group that have no values attached? Or a report that will include all objects but will indicate NULL for value?
Any insight into this would be greatly appreciated,
Thank you,
Olga.

...........................
Olga Zotova
Coordinator, Collections Database Administration
Collection Information & Resources
AGO - Art Gallery of Ontario
416.979.6660 ext. 262
[log in to unmask]<mailto:[log in to unmask]>
www.ago.net<http://www.ago.net>


Up next at the AGO: Alex Colville, honouring the legacy of a Canadian icon with more than 100 works. Opens August 23.

This message is a private communication. It may contain information that is privileged or confidential. If you are not the intended recipient, please do not read, copy or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you.
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.

ATOM RSS1 RSS2