Max Wanadoo
max.wanadoo at gmail.com
Sat Oct 3 11:06:38 CDT 2009
Top of head.. Are there other conditions in the select query and the Is Null is an OR? Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: 03 October 2009 16:58 To: 'Access Developers discussion and problem solving' 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/>