[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