Jagadisha N

Jagadisha N

  • NA
  • 5
  • 1.4k

How to retrieve latest data from MS Access database?

Jun 10 2013 2:53 AM
Hi can anybody tell me how to get the latest data logged in database while sending the query. Like i have MS Access database in which i have logged data along with time-stamping, so when i send a query i should get only the latest information stored in it or get the latest data from it based on the last recorded time.

My access database has the following data:

DEVICENAME                WINDOW        DATE                 TIME

Device1                           WIN1         6/10/2013         11:16 AM

Device1                           WIN2         6/10/2013         11:16 AM

Device2                           WIN7         6/10/2013         11:16 AM

Device2                           WIN7         6/10/2013         11:16 AM

Device1                           WIN1         6/10/2013         11:20 AM

Device1                           WIN2         6/10/2013         11:20 AM

Device1                          WIN3         6/10/2013          11:20 AM

As you can see device1 is logged twice @ different intervals, but from these logged data i need only the latest logged data i.e., device1 logged @ 11:20AM. How do i initiate a query for this case.



Answers (2)