Which part of "you are going about it the wrong way" did you not understand?
Basically, what you are asking is not possible given the restrictions you
have put on the solution. There is no other way to determine which items are
missing from a list when you don't have a list. That's what the table of
numbers is about. If you have that, you can do a simple outer join and
determine the missing members. Sure, you can write some code to add records
to your table, but that only solves the immediate problem.
So how about you take everybody's advice and do what they tell you and then
try from there instead of telling us that we don't know what you mean?
Wouldnt that be more productive?
Allen Browne has a nice example of Quantity On Hand on his website.
www.allenbrowne.com
Start there and then see how far you get.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200912/1