Hi all,

Good day.

I have a form with a Text Field (TxtDate), List Box (List0) and Command 
Button (CB1). The CB1 Click Event will run a query (Qry1) based on a item 
selected in List0. Qry1 contains Last Transaction Date and BatchID fields.

For example, I select BAT01 and click CB1. The query retrieves all records 
for BAT01 say 10 records. The last transaction date for 10th record is 
05/03/2002.

QUESTION:
How do I delete all records except the 10th record and display the Last 
Transaction Date in TxtDate field. I must do this once CB1 is clicked.

Thanks,
Maha