query oldest pending record

  • Thread starter Thread starter twalsh
  • Start date Start date
T

twalsh

I have a table that has issues submitted by employees. The Status column is
defaulted to "Pending". I want the ticket workers to be able to hit a command
button that will just present the oldest record with "Pending" in the
"Status" field for them to work. (i dont want to just present them a list of
pending tickets as they have a habit of picking and choosing the easier ones)

Table Architecture:

ID l EmplID l acct_num l Submit_time l Submit_dt l Issue l Status l
Completed_By
 
Back
Top