Get Recent Record without Id or date

[pyog]

I want to get recent record from table without considering Id or Date



Please Help

[orange]

Well you're going to have to tell us more. We can't guess what your table and field might be.
If you want help, tell us
-what your trying to do exactly,
-show us what you have tried, and
- what errors did you receive (if any)?

[pyog]

Thanks for your quick reply.

I want to fetch recently added record
In table there are 5 field and at every 1 minute entry added in database table
table does't have any primary key or any date field

So I need recent record entry
(Table already created by another person and application is running over that database)

[orange]

Get some sort of record number on your table. And increment it with each new record.

What does recently mean? In the last week, month,hour???

If getting a recently added record (whatever that might mean) is a requirement, then the database structure is not meeting requirements.

[pbaldy]

I agree that there are design issues. You can try Last() or DLast(), which I've never had a need for but theoretically find the last record entered:

http://support.microsoft.com/kb/208190

[orange]

Be cautious of Last, there is a lot of info saying it can not be trusted. DLast may be a better choice.
Regardless, you have a structure issue that you should correct.