I have a query that gathers start and end dates from several work cells. Below, I only list two.
I need to record the dwell time days it takes to get from one cell to another
. For example on the first line, from RELEASED TO FAB to CUTTING START would be 72 days.
However, on the second line, it skips the cutting cell, therefore from RELEASED TO FAB to MACHINING START would be 56 days.
I only listed two cells. There are six cells total and not every cell is used for every job.
I'm trying to figure out how to approach this perhaps with an iif statement but it's making my head spin.
Any help would be appreciated,