Rocky Smolin
rockysmolin at bchacc.com
Sat Oct 3 10:57:42 CDT 2009
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/>