Are you trying to do this as a SQL query or in Crystal Reports? On Oct 28, 2015 11:34 AM, "Milby, Jessica" <[log in to unmask]> wrote: > Hi everyone, > > We are trying to get a snapshot of the locations of objects saved in a > package for a specific time period. I know what was on view at the time, > but I’d like to know where everything was. These might have moved in > before or during our date range, might still be there, or might have since > moved out. We’re finding the TransDate isn’t adequate for those reasons, > and the DateOut hasn’t proven very useful. For 6600 objects, the data we > have yields over 33,000 results--too many for my project timeline. > > Does anyone have a script/view/report that can help us out? > > It seems like a simple question until you dive into the ObjLocations and > the available date fields. I feel like this kind of historical snapshot > ought to be available…we’re working on something non-incident related, but > I can imagine how a late discovery of a conservation issue, or building > incident could lead to needing this sort of thing. Usually we’d be > reporting on current locations, but the crux of this is that it’s > historical ones. > > Any help…? > > Thanks, > > Jessica > > > > > > > *Jessica Milby* > Assistant Director for Collection Information > > t 215-684-7283 > f 215-235-0035 > > > *Philadelphia Museum of Art *PO Box 7646, Philadelphia, PA 19101-7646 > www.philamuseum.org > > 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.