Prev: Protecting text boxes in forms
Next: Graphs and charts in Access 2007
From: mls via AccessMonster.com on 12 Apr 2010 14:28
Using 'Select Top 10' gives me first 10 rows of my table. I need to retrieve
the next 10 records.
I am writing to an excel spreadsheet where I need to write top 10 rows
starting from B2 and next 10 records starting from I2. So how can I split
them? Every time I have to split into 10rows each.

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1

From: ghetto_banjo on 12 Apr 2010 14:43
Something like this will get the job done. I don't know your table/
field names...

SELECT TOP 10 primaryKey FROM myTable
WHERE primaryKey NOT IN (SELECT TOP 10 primaryKey FROM myTable ORDER
BY....)
ORDER BY ...



 | 
Pages: 1
Prev: Protecting text boxes in forms
Next: Graphs and charts in Access 2007