Hi,
I have a table ordered by operation number ON, with others two fields Department, and ETD (Estimated time)
I need to make an update query to change the ETD values where the department Milling CNC or Lathe CNC will appear two times.
For example op no 80 and the next 100 are in the same department Milling CNC, so the ETD I need to be 0 for the second operation only (100), The third operation 110 should not be changed even if is in the same department Milling CNC
As an example, here is the table with the initial ETD values and after update:
https://pasteboard.co/I5jqKwl.jpg
Do you have an idea how this can be done?
Thank you!
I have a table ordered by operation number ON, with others two fields Department, and ETD (Estimated time)
I need to make an update query to change the ETD values where the department Milling CNC or Lathe CNC will appear two times.
For example op no 80 and the next 100 are in the same department Milling CNC, so the ETD I need to be 0 for the second operation only (100), The third operation 110 should not be changed even if is in the same department Milling CNC
As an example, here is the table with the initial ETD values and after update:
https://pasteboard.co/I5jqKwl.jpg
Do you have an idea how this can be done?
Thank you!
