Jim Lawrence
accessd at shaw.ca
Fri Feb 2 13:23:16 CST 2007
Comment... -1 is TRUE in Access. In MS SQL, TRUE = 1 (Strange?) Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia Sent: Friday, February 02, 2007 7:15 AM To: accessd at databaseadvisors.com Subject: [AccessD] Fields with Null I get -1 **************** Mmm, doesn't do that for me. Are you sure the Comments field is null? Could it have blank spaces in it somehow? Add this to your query: TestNull: IsNull([Comments]) Do the "empty" Comments records return -1 (ie True)? -- Andy Lacey http://www.minstersystems.co.uk -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com