Hi, I am trying to create a report that will give all the telephone numbers between 0001 and 9999. The problem is that only some of the number are in the database. I need the report to fill in the gaps of the missing numbers. For instance, let say that 0123, 0124, 0128 are in the database. I need the report to show all the numbers...
0123 (in database)
0124 (in database)
0125 (created by report)
0126 (created by report)
0127 (created by report)
1028 (in database)
I can't simply check to see if the previous number is in sequence because I need all numbers from 0001 to 9999. Can anyone help me out?
Thanks in advance.
Ed
0123 (in database)
0124 (in database)
0125 (created by report)
0126 (created by report)
0127 (created by report)
1028 (in database)
I can't simply check to see if the previous number is in sequence because I need all numbers from 0001 to 9999. Can anyone help me out?
Thanks in advance.
Ed