TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
2
)
C Sharp Exception Handling
Run RegisterStartupScript multiple times in c#