last 20 records criteria

eyalpel

New member
Local time
Today, 12:35
Joined
Jan 3, 2014
Messages
5
Hi All
i am pretty new for access 2007 so forgive me for the stupid question:
i like to create a querie which will give me the last 20 records in one of the tables.
i do not like to do it according to date.

Thanks
Eyal
 
There is no order to records in a table. You use a query to select and order records on some criteria.

What exactly do you mean by "last"?
 
HI
i meant to filter the last records that the user entered to the table.
may be it can be by the record ID?
 
Do you have a pointer / number showing the order in which a record is entered into the table?
 
Hi
I have the record ID which is automatically given by the DB.


Thanks
Eyal
 
Do your records have a datestamp, like DateCreated or DateEntered?
 

Users who are viewing this thread

Back
Top Bottom