You could pick-up NextId from aradmin.arschema, and use it to reverse-loop through your form, Setting a decrementing NextID by 1, incrementing a field for each record found - until you get as many as you want. The last Request ID found would be the first of the last x record ('sounds like you want 5). Armed with this 5-th-from-last Request ID, you can select all records greater that it minus 1.
Just off the top of my head, anyway... Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] "Joran, Peter P CTR OSD CIO" To: arslist@ARSLIST.ORG <Peter.Joran.ctr@ cc: OSD.MIL> Subject: Re: Query question Sent by: "Action Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 10/19/2006 14:09 Please respond to arslist I need to put in a Crystal report. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Thursday, October 19, 2006 2:05 PM To: arslist@ARSLIST.ORG Subject: Re: Query question How do you want to present the results, probably in a table? In that case you could sort the records based on the timestamp and limit the chunk size to 5.. George On 10/19/06, Joran, Peter P CTR OSD CIO <[EMAIL PROTECTED]> wrote: > ** > > All > This seems like a very simple question but I'm stumped. > How can I return just the oldest 5 records from a query? It's a metric > that is almost useless but the customer is not budging. > > Many Thanks! > Pete __20060125_______________________This posting was submitted with > HTML in it___ > __________________________________________________________________________ _____ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org #### smime.p7s has been removed from this note on October 19 2006 by Michael W. White _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
smime.p7s
Description: Binary data