View Full Version : NEED HELP - displaying highest entry in query...


truth_ip
09-23-2002, 03:45 AM
PLEASE HELP ME!!

I am using a query and I need to find out how to display only the highest entry (by ID #)... I need to be able to print only the latest set of data from the database. (I think we are looking for the formula to filter within the query)...

I know it is possible, but could you please help me!?!?

Thanks,

Alex and Jenny

BLeslie88
09-23-2002, 04:44 AM
Select Top 1 tblXXX.*
From tblXXX
Order By tblXXX.ID Desc;
.. or Asc;
I always mix the 2 up... :)

Hope this helps....