Record Number automated in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi -

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