How to generate series of numbers between two numbers

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Anshu12
    New Member
    • Apr 2012
    • 3

    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..
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Use a loop. That's ask I can say since you have given us so little information.

    Comment

    • Anshu12
      New Member
      • Apr 2012
      • 3

      #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.

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        What you want to do with those numbers after generation. Simply display or do any other processing.

        Comment

        • Anshu12
          New Member
          • Apr 2012
          • 3

          #5
          I have to compare these numbers with my another data table

          Comment

          • debasisdas
            Recognized Expert Expert
            • Dec 2006
            • 8119

            #6
            this will generate the numbers for you.

            Code:
            For i = 1 To 10 Step 1
            Print i
            Next i
            You an use the numbers the way you want.

            Comment

            Working...