Missing value

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

John Smith

Here's my problem:

I have a list of value
1 to 49 that are for a part of a plant (PLANT1)
50 to 69 that are for a part of a 2nd plant (PLANT2)
70 to 89 that are for a part of a 3rd plant (PLANT3)

When I'm choosing PLANT1, I want a list that will exclude all number that
are already been used?

For exemple, if the number 1,5 to 10 and 17 are used, the list should
contain number 2 to 4, 11 to 16 and 18 to 49.

Any Idea?

Thanks

JS
 
I presume that you can extract the information via queries (versus vba
coding).

Try something like this: (For discussion purposes, I will use PlantNumber to
represent the numbers)

Select *
From Plant1
Where PlantNumber Not In
(
Select Distinct PlantNumber
From Plant1
)

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top