473,320 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to generate series of numbers between two numbers

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
5 2906
Rabbit
12,516 Expert Mod 8TB
Use a loop. That's ask I can say since you have given us so little information.
Apr 10 '12 #2
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
debasisdas
8,127 Expert 4TB
What you want to do with those numbers after generation. Simply display or do any other processing.
Apr 10 '12 #4
I have to compare these numbers with my another data table
Apr 10 '12 #5
debasisdas
8,127 Expert 4TB
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

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

Similar topics

2
by: Christopher M. Pieper | last post by:
I want to generate a resultset that is just a series of numbers in ascending order or perhaps a series of dates.. What I mean is, is there a way to generate a temporary table of dates given an...
12
by: Jim Michaels | last post by:
I need to generate 2 random numbers in rapid sequence from either PHP or mysql. I have not been able to do either. I get the same number back several times from PHP's mt_rand() and from mysql's...
9
by: MyInfoStation | last post by:
Hi all, I am a newbie to Python and would like to genereate some numbers according to geometric distribution. However, the Python Random package seems do not have implemented functionality. I am...
6
by: Anamika | last post by:
I am doing a project where I want to generate random numbers for say n people.... These numbers should be unique for n people. Two people should not have same numbers.... Also the numbers...
2
by: Robert Waggoner | last post by:
I have a table which holds certification numbers that come in batches. The numbers will run from (for example) 456 to 496. I have to enter these numbers individually. Is there a code I could use to...
3
by: mail2pragati | last post by:
Hellp all, I want to generate the alpha numeric numbers (like : A-0001/0708,S-0010/0708) as soon as the form is loaded. Is it possible using Java Script. And then these generated numbers are stored...
3
by: scAry008 | last post by:
hi i am scAry,from phillipines.A beginner about java programming.Anybody can help me? i need a code to how to write a java program that will ask for five numbers and will display the largest one by...
4
by: ulas | last post by:
Hi, I am designing a table in SQL Server 2008 which will contain, in each row, a list of numbers of variable length. The maximum (10) and minimum (2) list lengths are known. The most obvious...
2
by: cheetahhonda991 | last post by:
I want to write a c program to print sum of series of numbers. Can anyone please send me the program code.
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.