outputting certain rows in a query 1

[ecintern]

I am running a query that may have up to 300 hits. I only want to return 25 of them at a time, giving the user the option of viewing the next 25 or the previous 25. What is the sql syntax needed to do this

 

[ghubbell]

Go to the query in design view. There is "combobox" at the top on the toolbar that probably says "All". Type in 25..! Gord
ghubbell@total.net

 

[SteveR77]

If there is a need for flexibility you might want to check this out as well.

[bold]Using Query to Return Every Nth Record from a Table[/bold]

http://support.microsoft.com/suppor...uery&rnk=6&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

HTH

Steve B-)