I have only 3 tables tbl_incident, tbl_incrpt_notes, tbl_location. I have a query which has only ID and depot. I have to get back to my real job right now but I'll have another try on the weekend. If you could kindly have a look and as I say I not sure if I have the right structure for what...