query oldest pending record

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto populate field when query run 1
"UNION" Query with different fields in the two tables 3
Best Way To Query The Following Information 8
I am trying to write a database to record which employees are pre 1
Populating fields via a Record Select Combo 3
Forms - Multiple Users - Record viewing in form 3
Displaying a query as a subform?! 1
Delete query following append query from table in relationships 3

Top