Hello,
Rupert is correct that you need to use the Date Out and Transaction Date to
pick up things that were in there. You don't have to use NULL with the Date
Out because it stores 12/31/9999 as the date out for works that haven't
moved. Both the Transaction Date and Date Out should come from
Objects>Object Components>Location History in db config manage query
groups. The example advanced query below picks up everything that was in
the Herzfeld Study Center in 2011 including the subsites and things that
moved in in 2010 and didn't move out until 2013.
Hope this helps!
[image: Inline image 1]

*Stephanie Hansen*

*Associate Registrar/Database Administrator*

*Milwaukee Art Museum*
700 N. Art Museum Dr.  |  Milwaukee, WI 53202
Tel. 414.224.3273   |   Fax. 414.271.7588  |   [log in to unmask]




On Tue, Aug 23, 2016 at 3:28 AM, Shepherd, Rupert <
[log in to unmask]> wrote:

> Dear Christine
>
>
>
> Well, I’m still learning my way around the system, but I think this sits
> in:
>
>
>
> Objects à Object Components à Locations, where you will find Date Out.
>
>
>
> Failing that, you could of course always circumvent advanced search and go
> straight to a Crystal Report which has the query criteria embedded within
> it.
>
>
>
> Best wishes
>
>
>
> Rupert
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]]
> *On Behalf Of *Christine Droll
> *Sent:* 22 August 2016 14:24
> *To:* [log in to unmask]
> *Subject:* Re: Search Help
>
>
>
> Thank you for this possible solution, Rupert.
>
>
>
> In order to set up the Advanced Search, I am trying to find the field for
> Actual End Date in the Query Groups in the dbconfig, but to no avail. Can
> you bear with me a little more and point me in this direction?
>
>
>
> Many thanks,
>
> Christine
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]
> <[log in to unmask]>] *On Behalf Of *Shepherd, Rupert
> *Sent:* Monday, August 22, 2016 3:54 AM
> *To:* [log in to unmask]
> *Subject:* Re: Search Help
>
>
>
> I may be being obtuse here, but there’s also the Actual End Date field,
> over on the right of the Location History card of the Location & Movement
> form. So I think the logic you’re looking for would be:
>
>
>
> Date <= [search date] and (Actual End Date > [search date] or Actual End
> Date is null)
>
>
>
> (You need the null in case the object moved into that location and is
> still there.) The underlying field names should be ObjLocations.TransDate
> and ObjLocations.DateOut.
>
>
> We’re trying to do something similar at the National Gallery: produce a
> series of collection statistics, including how many objects were on or off
> display, for any given date.
>
>
>
> Best wishes
>
>
>
> Rupert
>
>
>
>
>
> *Rupert Shepherd, PhD FSA*
>
> Collection Information Manager
>
> [log in to unmask]
>
> Tel: +44 (0)20 7747 5921
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]
> <[log in to unmask]>] *On Behalf Of *Christine Droll
> *Sent:* 19 August 2016 22:43
> *To:* [log in to unmask]
> *Subject:* Re: Search Help
>
>
>
> I, too, haven’t figured out a way to do this. Using the transaction date
> (>= and <=) only works if the location has been added or changed during
> that timeframe. It doesn’t capture the other times. So if I wanted to find
> out if this object was in the gallery in 2011 using >= 1/1/2011 and <=
> 12/31/2011, it wouldn’t find it, even though it was there.
>
>
>
>
>
>
>
> Christine
>
>
>
> *Christine Droll*
>
> *Registrar, Database & Collections*
>
> *The Nelson-Atkins Museum of Art*
>
> 4525 Oak Street | Kansas City, MO 64111
>
> *p* 816.751.1333 | *f* 816.751.0499
>
> [log in to unmask]
>
>
>
>
>
>
>
> *From:* The Museum System (TMS) Users [mailto:[log in to unmask]
> <[log in to unmask]>] *On Behalf Of *Lucille Stiger
> *Sent:* Monday, August 15, 2016 3:05 PM
> *To:* [log in to unmask]
> *Subject:* Search Help
>
>
>
> Hi Everyone,
>
>
>
> I've been asked to provide a list of objects that were exhibited in a
> particular gallery in a given year. The location has multiple sub-sites
> attached with it, and the objects exhibited there are not necessarily
> associated with an exhibition because it is one of our permanent collection
> galleries.
>
>
>
> Perhaps I have a case of "It's Monday and my Brain Hasn't Kicked In," but
> I've looked through the Advanced Queries and don't see anything that would
> apply.
>
>
>
> We used to print out a Gallery Checklist every time something was added or
> removed, but we stopped doing this years ago. Perhaps we shouldn't have!
>
>
>
> Best,
>
>
>
> Lucille
>
> Lucille Stiger
> Registrar
> Allen Memorial Art Museum
> 440.775.8668
>
> 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.
>
> 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.
>
> 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.
>
> 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.
> 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.
>

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.