query oldest pending record

[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

 

[twalsh]

Nevermind, i figured it out....

 

[hunterpaw via AccessMonster.com]

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

Hi twalsh,

You can try adding this code to your Command Button Click Procedure:

Dim strSQL As String

strSQL = "SELECT TOP 1 * " & _
"FROM MyTableName " & _
"WHERE Status = 'Pending' " & _
"ORDER BY Submit_dt DESC, Submit_time DESC;"

Me.RecordSource = strSQLB
Me.Requery

Best Regards,
Patrick Wood
http://gainingaccess.net