[AccessD] Mysterious Data Problem

Bill Patten bill_patten at embarqmail.com
Sat Oct 3 12:19:59 CDT 2009


Oops, guess I need to learn how to read. Sorry.

B

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Saturday, October 03, 2009 10:08 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Mysterious Data Problem

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list