NEED HELP - displaying highest entry in query...

[truth_ip]

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]

This would work...

Select Top 1 tblXXX.*
From tblXXX
Order By tblXXX.ID Desc;
.. or Asc;
I always mix the 2 up...

Hope this helps....