David,
That last query did it! You rock :).
I was trying to get the total for the WSI as a whole as well as the
total that were defects and that did it. It now makes a very nice
recordset which can be used in the page (all in one trip)!
A big thanks goes to Jay and Tim also for getting the discussion going.
It is great to know that there are smarter people in the world than
myself 😉
Drew