how to generate sequential numbers with access

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

Guest

I want to generate sequential numbers by giving from and to . what can I do
about that ?
 
It is easy if you use the autofill in Excel.

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.
 
I want to generate sequential numbers by giving from and to . what can I do
about that ?
Click to expand...

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]
 
Back
Top