Returning a range of missing value

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
 
J

John Smith

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top