Hi, It is possible through Crystal Reports. You have to create a View in Sql Server first (a 'union' query), then you use this in your report. The query lists all loans twice: -with the beginning date substracting (-) days you want the work(s) to be ready for shipment -with the end date adding (+) days you must have the work(s) be returned to your institution after the loan. Add all other tables/fields in your report. Use Status-fields to filter loans (for example: for loans that have left your institution but not yet returned, loans that were in the past that are not needed in the report, etc.) The view must be sorted by 'plandatum' Example: CREATE VIEW dbo.LOANSPLANNING AS SELECT LoanID, LoanNumber, ConstituentID, 'begin' AS [begin], CONVERT(datetime, substring(BeginISODate, 1, 4) + substring(BeginISODate, 6, 2) + substring(BeginISODate, 9, 2)) - 21 AS [plandatum], BeginISODate AS [totaaldatums] FROM Loans UNION ALL SELECT LoanID, LoanNumber, ConstituentID, 'eind' AS [begin], CONVERT(datetime, substring(EndISODate, 1, 4) + substring(EndISODate, 6, 2) + substring(EndISODate, 9, 2)) + 18 AS [plandatum], EndISODate AS [totaaldatums] FROM Loans André Straatman Registrar Kröller-Müller Museum, Otterlo, Holland ________________________________ Van: The Museum System (TMS) Users [mailto:[log in to unmask]] Namens Kelly Rushing Verzonden: dinsdag 10 april 2007 16:09 Aan: [log in to unmask] Onderwerp: Re: TMS as a reminder tool Please respond to the list. I would also like to know if this is possible. Right now, I enter all the expiration dates into my Microsoft Outlook calendar and set it to remind me two weeks in advance. I also have the calendar set to remind me to check for upcoming loan expiration dates in TMS every month. Kelly Rushing Registrar Eiteljorg Museum of American Indians and Western Art 500 W. Washington St. Indianapolis, IN 46204 Phone: 317-275-1359 Fax: 317-275-1459 ________________________________ From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Lourdes M. Ranero Guzmán Sent: Tuesday, April 10, 2007 9:54 AM To: [log in to unmask] Subject: TMS as a reminder tool Greetings fellow TMS users, I have a question and hope anyone could answer me. We want to use TMS as a reminder tool. Is there a way to set TMS to inform us when is the due date for a loan or there is a due date for shipment? Thanks. Lourdes M. Ranero Museo de Arte de Puerto Rico