Inserting numbers:starting from a particular given number and ends at another given number

[sureshchittilamchery]

Please provide a solution to insert continuous numbers from a given starting number to a given ending number in a report in access. for example starting number is 345251 and last number is 345726. the first record of report should start with 345251 second record 345252 and so on ,ends at 345276 for last record

 

[mole999]

if your doing it in excel, maybe dedicate two cell, one with the start number, the other with the end number, or the numbers of events you want to use

in VBA

Dim "your steps"

For "your steps" equal cellA to CellB step 1

"your steps" = "your steps" + 1
then wrap with
next "your steps"

 

[sureshchittilamchery]

sir is it possible to use directly in ms access 2007 ?.

 

[mole999]

you should be able to create an auto updating invoice number field in access, long time since I have done anything like that, but as you create a new record that should work