Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Missing nr

Status
Not open for further replies.

staleb

Programmer
Feb 7, 2005
45
NO
Hi
I have been looking throug the threads in search for an answer. But couldnt fing one that I could turn in my favour
My problem is:

I have a table of cases which is given a specific nr.
If the user enters two numbers, he would get a report showing the missing numbers between his interval:

Example:

In my table I have casenr 12, 14 ,24 ,25 and so on
The useres enters 10 and 20

Then the report should show this
10,11,13,15,16,17,18,119,20

How would this be solved?



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top