How to create a List subset of 10 each

  • Thread starter Thread starter deefish99 via AccessMonster.com
  • Start date Start date
D

deefish99 via AccessMonster.com

I have a project that I am not sure how to do...

I have a list of 5000 names and I need to create lists of 10 names for each
list.

I have not created a table yet, so I can do whatever I need. Once the lists
"subsets" are created, I will print each list of a seperate page in a report
which I can figure out. But I can not figure out how to "tag" 10 records as
List 1, next 10 as List 2...etc.

Any ideas or code that can help?

Thanks for much for responding!!!! Greatly appreciate it!

Dee
 
All you need is an autonumber key in your table. You will then be able to
calculate which list each record belongs to based on the autonumber key (once
you know the lowest number which you can find via DMin function).
i.e. listnum = Cint(K-MinK-10)/10)
Where K is the autonumber key and MinK is the first autonumber value
You could even insert this number via a query to a column in the table.
Print the records in autonumber order, ten to a page.

-Dorian
 
Thank you so much for your quick response!

I am having a little difficulty with the formula below. Missing a
parenthesis. I am trying to put this in a query with the autonumber field
called ID. Can you rephrase the formula for me please?

All you need is an autonumber key in your table. You will then be able to
calculate which list each record belongs to based on the autonumber key (once
you know the lowest number which you can find via DMin function).
i.e. listnum = Cint(K-MinK-10)/10)
Where K is the autonumber key and MinK is the first autonumber value
You could even insert this number via a query to a column in the table.
Print the records in autonumber order, ten to a page.

-Dorian
I have a project that I am not sure how to do...
Click to expand...
[quoted text clipped - 11 lines]
Dee
Click to expand...
Click to expand...
 
Oops, it should be
listnum = Cint((K-MinK-10)/10)
Where K is the autonumber key of the current record and MinK is the lowest
autonumber key
You can find the lowest autonumber key with
MinK=DMin("Keyname","tblMytable")

-Dorian


deefish99 via AccessMonster.com said:
Thank you so much for your quick response!

I am having a little difficulty with the formula below. Missing a
parenthesis. I am trying to put this in a query with the autonumber field
called ID. Can you rephrase the formula for me please?

All you need is an autonumber key in your table. You will then be able to
calculate which list each record belongs to based on the autonumber key (once
you know the lowest number which you can find via DMin function).
i.e. listnum = Cint(K-MinK-10)/10)
Where K is the autonumber key and MinK is the first autonumber value
You could even insert this number via a query to a column in the table.
Print the records in autonumber order, ten to a page.

-Dorian
I have a project that I am not sure how to do...
Click to expand...
[quoted text clipped - 11 lines]
Dee
Click to expand...
Click to expand...
Click to expand...
 
Back
Top