Returning a range of missing value

  • Thread starter Thread starter John Smith
  • Start date Start date
J

John Smith

Hi everyone!

'---------------------------------
I have a table name Owner:

OwnerName
Start
End

Exemple:

OwnerName = PLANT1
Start = 1
End = 49

OwnerName = PLANT2
Start = 50
End = 69

'-------------------------------

A second table with number from 1 to X

When I'm selecting PLANT1 one from my comboBox, I want to return the missing
value between the start and the end of the selected Plant...

Hope I was clear!

Thanks!

JS
 
Sorry,

It's link to another table with number in it. Some number are used and some
are note

For exemple:

Number 1,2,3, 10-15, 17, 21 are use

I'm searching a way to have the missing value (4 to 9, 16, 18 to 20 and 22
to 49)
 
Back
Top