[General] Title=Labels per number (24mm) (Comar) Length=5cm MarginLR=4mm MarginTB=4mm [Prompts] 1=First @g|TEXT 2=Last @g|TEXT 3=Active @gs|ON 4=Inactive @gs|OFF [Rows] 1=Calib. Date: %1|8 2=Done by: %2|8 3=Next Calib: %3|8 4=@G number: %4|8 5=Q-03: Form #1225-Q Rev. B|8 [SQL] 1=SELECT FORMAT(LastCalibDate, "Short Date"), DoneBy, CalibDueDate, GageNumber, Active 2=FROM Gages, Events 3=WHERE (GageNumber >= '%1' AND GageNumber <= '%2') AND (Events.EventId=(SELECT TOP 1 EventId FROM Events WHERE ((GageId=Gages.GageID) AND (EventType=0)) ORDER BY EventDate DESC)) 4=AND (Active = %3 OR NOT (Active = %4)) 5=ORDER BY Active, GageNumber