Hi,
Some help needed please. I am building a query/report based on our job completion performance. However, I am using a number of tables including labordtl to get the Clock in date. However, I am getting duplicate rows because some jobs contain more than one operation. Where jobs have more than one operation, I would just like to filter on the highest/latest operation sequence. Does anyone know how I can achieve this?
jDJ