[General] Title=Calibration label (per number) - Calibrated by Length=4cm MarginLR=6mm MarginTB=1.4mm [Prompts] 1=First @g|TEXT 2=Last @g|TEXT '3=Active @gs|ON '4=Inactive @gs|OFF [Rows] 1=@G: %1|4 2=Calib due: %2|4 3=Cal Date: %3|4 4=Entered by: %4|4 [SQL] 1=SELECT GageNumber, CalibDueDate, FORMAT(LastCalibDate, "Short Date"), DoneBy 2=FROM Gages, Events WHERE (Gages.GageNumber>='%1') AND (Gages.GageNumber<='%2') 3=AND (Events.EventId=(SELECT TOP 1 EventId FROM Events WHERE 4=((GageId=Gages.GageID) AND (EventType=0)) ORDER BY EventDate DESC)) 5=ORDER BY GageNumber