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

  • Follow
  • Get RSS Feed

2 Answers

  • 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

  • Apr 10 at 06:10 PM

    Report code will be an eliminator. So, let's say the operation code is laser, this will appear on the laser report, but not the reports for the other departments.

    Add comment
    10|10000 characters needed characters exceeded