Record Number automated in Query

N

NL

How can I get the record number in a query that shows at the botton on the
navigation bar? I have one table with 65 records. I want to divide this
table in queries of 20 records only in alphabethical order(name field); if
query 1 is from A-F, then query 2, should conitnue from F if record #21 still
has a name with F, etc, etc. How can I do this?

Thank you.
 
R

raskew via AccessMonster.com

Hi -

Take a look at the Partition() function (see help file). If your breakdown
is consistent, this might be helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
QBF & Query Malfunction 0
Merging from an Excel file with graphics 1
query to show where no data in a stated column 0
Append only new records/entire record makes unique identifier 4
Creating a Chart on form from selected data in query. 0
Pipe character in query in VB6 app 11
Using IIF statement in query criteria 11

Top