Add range of numbers

[essmessm]

I have a group of ticket books, 25 per book. The first number is 1-25 and the 26-50 and so on. Is there a way to input the first number and have the table populate with the rest so when the tickets are turned in they can be paired with the person they were distributed too?

thanks

Steve

 

[Remou]

You could run a little code. For example:

For i=0 to 24
  strSQL="INSERT INTO SomeTable (TicketID) " _ 
  & "VALUES ( " & Me.txtStartNumber + i & " )"
  CurrentDB.Execute strSQL, dbFailOnerror
Next

Where Me.txtStartNumber comes from the form.

 

[MichaelRed]

Since you apparently know the number of books, modify Remou's code to just loop through the entire set of values.




MichaelRed

 

[essmessm]

Thank you both, I will try this