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

Susan Harkins ssharkins at bellsouth.net
Tue Apr 20 21:35:53 CDT 2004


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.





More information about the AccessD mailing list