Filtering the first record

[scubadiver]

At the moment I have a button in a subform that appends the information to
another table and deletes it from the current table.

What I would like to do is put the button on the main form and change the
append and delete queries so that it only deals with the record with the
lowest ID number.

How can I do it?

cheers

--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org

 

[scubadiver]

If I have searched that little bit longer I would have discovered the "DMIN"
function.

DMin("[QueryID]","tble_queue")