Hi Rob Are you able to run SQL queries in SSMS? I have attached two SQL queries - CountObjectMoves_PerYear will give a total of object moves each year and ObjectMoves_PerPeriod gives details on location, handler, object number etc. You need to enter your preferred date range in the where clause with this query. You can further select on DepartmentID or ObjectStatusID if needed. I think they are correct, but if they don't return the expected results or aren't what you were looking for, let me know. Kind regards, Sally From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Rob Morgan Sent: Saturday, 11 October 2014 12:56 AM To: [log in to unmask] Subject: Number of object moves per year Hello everyone, Has anybody run a query that tracks the number of object moves per year? Thanks everybody, Rob Morgan Collections Database Administrator The Baltimore Museum of Art 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. Sally Fletcher Manager Registration Australian National Maritime Museum Darling Harbour 2 Murray Street NSW 2000 +61292983726 +61418438273 www.anmm.gov.au<http://www.anmm.gov.au> [http://www.anmm.gov.au/~/media/Media/icons/banner.jpg]<http://www.anmm.gov.au> Join: eNewsletter<http://www.anmm.gov.au/get-involved/share-and-connect> [social media icons] ********************************************************************************* This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited and may incur severe penalties. If you have received this transmission in error, please notify us immediately by telephone on 02 9298 3777 and delete all copies of this transmission together with any attachments. 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.