MHurdatADP
Technical User
Earlier, I had a thread where I got "no rows found" when trying to display current JOB row and previous JOB row, when no history existed. I found a fix for that: include a condition where the history effdt is either null or equal to the current row.
However, that adds a new problem: Where there is history, I now get two rows of data - one with the current and history data and one with the current data only. What am I missing? Or, how do I get it to display EITHER, not both? I am loading an attachment called "Too many rows.doc" with more details. Thank you for your assistance.
However, that adds a new problem: Where there is history, I now get two rows of data - one with the current and history data and one with the current data only. What am I missing? Or, how do I get it to display EITHER, not both? I am loading an attachment called "Too many rows.doc" with more details. Thank you for your assistance.