By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,894 Members | 2,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,894 IT Pros & Developers. It's quick & easy.

How to generate series of numbers between two numbers

P: 3
I want to generate series of numbers between two numbers (one is lower value and another is higher one) eg-My lower end value is 66660001 and higher end value is 66662000 then I want to generate all 2000 numbers in between these two numbers using VB code.
Please suggest some method..
Apr 10 '12 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 10K+
P: 12,366
Use a loop. That's ask I can say since you have given us so little information.
Apr 10 '12 #2

P: 3
Thanks for your reply but can you just ellaborate the thing?...I have designed one form in which two unbound values are present for two ranges ie lower range and higher range. As I mentioned earlier is there any function available to genarate series of numbers between two input values..Please suggest any query for this.
Apr 10 '12 #3

Expert 5K+
P: 8,127
What you want to do with those numbers after generation. Simply display or do any other processing.
Apr 10 '12 #4

P: 3
I have to compare these numbers with my another data table
Apr 10 '12 #5

Expert 5K+
P: 8,127
this will generate the numbers for you.

Expand|Select|Wrap|Line Numbers
  1. For i = 1 To 10 Step 1
  2. Print i
  3. Next i
You an use the numbers the way you want.
Apr 10 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.