Be sure to proof out your results using the COUNT feature if you are also including an ORDER BY, GROUP BY or have breakpoints set in a report. You just might not get the records you thought you were going to get ...
I can't remember the problem exactly but I think it might not sort before it does the count ... Sami Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 Fax 913-962-9431 mailto:[EMAIL PROTECTED] ----- Original Message ----- From: "Atrix Wolfe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 3:20 PM Subject: Re: limiting results from a select > it works...yay! > > thanks for your help > > ----- Original Message ----- > From: "Mike Willochell" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, August 13, 2002 12:47 PM > Subject: Re: limiting results from a select > > > > Try ...COUNT > 50 > > > > At 12:34 PM 8/13/2002 -0700, you wrote: > > >I know in R:Base you are allowed to say limit=100 to of course limit the > > >result to 100. I was wondering however if theres a way to say something > > >like start=50 so that it would ignore the first 50 results? > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
