Thank all of you. It works perfectly.

The EXCEPT is a nice spin (changed to IS NULL) on the cDate field.

Yes, "where any cDate is NULL in the set where jNMBR = 8000 and sNMBR = 1002" or for any jNMBR/sNMBR association (besides 8000 and 1002) that has a NULL...

Thanks to both of you. All three solutions work for my query.

Taking this a step further, what if I do not want to see the jNMBR and sNMBR at...

Luis, once again thank you for your help. The revised code works flawlessly in my application now. In a gridview, the TestType is now highlighted in the SampleNo...

Luis, thank for the reply and reference to proper protocol which I will save for future reference. Here is the information you requested:

====================================================================================

--===== If the test table already exists,...

Mister.Magoo,

Thank you for your help. AND NOT (P.PAprojmngrid IS NULL) was the key. It now works perfectly.