[AccessD] Query fails when using NOT IN ???

Susan's my name, dirty data's my game... ;) 

Glad to help. 

Susan H. 

AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUGH!

There were some nulls in the BlockID field of the TG_InvoiceLine table.  I
set those to 0 and the IN statement started to work again.

Heh.  What an idiot.

Thanks, everybody, and especially Susan for bringing up the dirty data
angle.