Rocky Smolin
rockysmolin at bchacc.com
Sat Oct 3 12:08:59 CDT 2009
Opposite problem here, I think. The query specified Is Null as a criterion. When I ran the query these ten records (among others) showed up with a value in the field that should have only bee Null. The value in the TruckID field was valid and should have been there. After the C&R, the query correctly did not return those ten records. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Saturday, October 03, 2009 9:07 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Mysterious Data Problem Hi Rocky, Though I never heard of compact and repair removing empty string '' or a space, when you look at them they look like a null but are not so isNull(x) will show false but look true. HTH Bill -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Saturday, October 03, 2009 8:57 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] Mysterious Data Problem Dear List: In the Containers Table a container that has a TruckID in the truck field indicates that that container is already in a shipment. So the list of containers available for shipping is based on a query which looks for containers in which the TruckID filed is null. When I ran that query 10 containers which were already in a shipment showed up in the query for unshipped containers anyway even though the field TruckID was obviously NOT null. I opened the back end did a compact and repair and that seems to have fixed the problem. But I don't know what caused it or why the compact fixed it. This has never happened to the user before and I've never seen it myself - a select query with a condition Is Null and it selects records in which that field is NOT null. Any ideas? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com <http://www.e-z-mrp.com/> www.bchacc.com <http://www.bchacc.com/> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com