Skip to Content

need first open in sequence

i have a table with sequences for our jobs in it. Each data set (operation) has the sequence number and an operation number and a status. Another table has our report codes that match up with the operation number. What I am trying to do is find the first operation that is open or started , use that operation code to get our report code and put that code on our report to sort by. It has been a while since I did something like this, so I can't remember what I did.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 07, 2018 at 07:11 PM

    Will Report Code be the outer group/sort? Or will the you group/sort by other things as well?

    -Dell

    Add comment
    10|10000 characters needed characters exceeded