Generate sequential numbers between 2 numbers 1

[FeS2]

In Access 2007, I am trying to figure out a way to take a number like 2271100 and then generate and insert into a table the remaining sequence of numbers up to 2271199, ie.. 2271101, 2271102 ...

I am wanting to do this using a query but have searched around and only been able to find how to do it in Oracle or T-SQL, not in Access.

Any help would be appreciated.

Thanks

 

[Golom]

Create a table of integers with one field (Num) and load it with the integers 0-9. Then

Select 2271100 + (I1.Num*10 + I2.Num) INTO SomeTable 

From Integers As I1, Integers As I2

Where I1.Num*10 + I2.Num < 100

 

[r937]

nice one, golom, you just beat me to it

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[Golom]

Rudy

Yeah ... but I stole it from you.

 

[FeS2]

This is exactly what I was needing. Thank you guys for the quick reply

 

[r937]

okay, except "stole" is not the right word at all

how's everything?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[Golom]

"stole" is not the right word at all

Plagerized? Pilfered? Absconded With? Expropriated?
Work with me here.

how's everything?

Well, I'm terribly worried about the baggage retrieval system at Pearson.
Other than that ... fine.

 

[r937]

learned from" would be better

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon