[AccessD] Mysterious Data Problem

No - no other criteria.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Saturday, October 03, 2009 9:07 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Mysterious Data Problem

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/> 

 

 


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