You can build a reference table named CountNUM and fill it with the numbers
from Excel to the maximum you will ever need. Then create a query with from
and to criteria prompts.
One pure-Access way to do it uses an auxiliary table. You can use
Excell fill-sequence to create a table Num with values N from 0
through the largest number you'll ever need (be generous, 10000 or
65536 say).
This table turns out to be useful in several cases (e.g. printing
Label 3 of 20).
John W. Vinson[MVP]
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.