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

 

[maxxximaniac]

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