E eyalpel New member Local time Today, 12:26 Joined Jan 3, 2014 Messages 5 Jan 3, 2014 #1 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
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
jdraw Super Moderator Staff member Local time Today, 15:26 Joined Jan 23, 2006 Messages 15,574 Jan 3, 2014 #2 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"?
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"?
E eyalpel New member Local time Today, 12:26 Joined Jan 3, 2014 Messages 5 Jan 3, 2014 #3 HI i meant to filter the last records that the user entered to the table. may be it can be by the record ID?
HI i meant to filter the last records that the user entered to the table. may be it can be by the record ID?
J JHB Have been here a while Local time Today, 21:26 Joined Jun 17, 2012 Messages 7,732 Jan 3, 2014 #4 Do you have a pointer / number showing the order in which a record is entered into the table?
E eyalpel New member Local time Today, 12:26 Joined Jan 3, 2014 Messages 5 Jan 3, 2014 #5 Hi I have the record ID which is automatically given by the DB. Thanks Eyal
jdraw Super Moderator Staff member Local time Today, 15:26 Joined Jan 23, 2006 Messages 15,574 Jan 3, 2014 #6 If you are talking about autonumber, they are only guaranteed to be unique --not sequential, not positive necessarily. see http://www.utteraccess.com/wiki/index.php/Autonumbers
If you are talking about autonumber, they are only guaranteed to be unique --not sequential, not positive necessarily. see http://www.utteraccess.com/wiki/index.php/Autonumbers
David R I know a few things... Local time Today, 14:26 Joined Oct 23, 2001 Messages 2,633 Jan 3, 2014 #7 Do your records have a datestamp, like DateCreated or DateEntered?