Equipment and Calibration

Equipment history at Eden Landing

| ALL |

SELECT a.recno, a.eh_date, a.eh_loc1, a.eh_loc2, IF(a.eh_loc2=:loc, a.eh_locref2, a.eh_locref1) AS ref, a.eh_locref2, a.eh_title, a.eh_notes, a.eh_id, b.serialno, b.equip, b.modelno FROM equiphist a INNER JOIN equiplist b ON a.eh_id=b.recno WHERE (a.eh_loc1=:loc1 OR a.eh_loc2=:loc2) ORDER BY b.equip, a.eh_date, field(a.eh_title,'Calibration', 'Removed', 'Installed')

Date	Serial No.	Model	Action	Ref	Notes

Export to BADM