Need to pull up only last record in a table

[maxxximaniac]

Hey,
So Im trying to make a qry with some other criteria, but I need only the last record to be pulled when the qry is ran. I can't think of anything. Any help??

Much Appreciated!
Thanks

 

[Pat Hartman]

"Last" means physically last in the recordset so I doubt that "Last" is what you are really after since "Last" changes depending on how a recordset is ordered. You probably want the record with the Max() date or key value. If that is the case, add an order by clause that orders descending on the important field and select the Top 1 records.

 

[maxxximaniac]

yes you are correct,
I have an autonumber,
what criteria do I enter to pull only the record with the greatest autonumber

 

[Pat Hartman]

I told you how to do it.

add an order by clause that orders descending on the important field and select the Top 1 records