[AccessD] A Mystery

There are nulls but the odd thing is how long this software has been running
(years) on these queries.  The queries were legacy and I haven't had to futz
with them.  

So even if I tried to eliminate the nulls (liberal use of Nz) I'm thinking
there n=must be something else odd going on.

But thanks for the leads - I'll take a look in the morning when my brain is
working.

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: August 22, 2011 6:44 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A Mystery

Two  things to  look for:

Most likely: Null entries in a sorted/filtered field or one of the source
fields of a calculated column.

Secondly: If you are using any functions in your query, check for
missing/broken references.

--
Stuart

On 22 Aug 2011 at 18:35, Rocky Smolin wrote:

> Dear List:
> 
> I have a client I helped with a legacy app - interesting business - 
> seed dealer - buys some and grows some on land in El Centro.  But I 
> digress.
> 
> I got a call today from the company - they're getting an error on 
> opening the mdb - "Data type mismatch in criteria expression".  The 
> opening form has as a Record Source a query that does indeed generate 
> that error when I run it.
> 
> So my first thought is that their network has corrupted the back end. 
> They sent me the back end and I can duplicate the error but there are 
> not apparent corrupted records.
> 
> I isolated the field in the query that causes the error but everything 
> looks dandy with that field.
> 
> I set up a DAO loop and read each of the records in several of the 
> likely tables, hoping one would blow and I could clean out a corrupted 
> record - but no cigar.
> 
> I didn't ask them if anything changed in their system right before 
> this happened - I'll have to ask them tomorrow. But everybody has the 
> same problem.
> 
> I'm at a loss.  Any WAGs?
> 
> MTIA
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com 
> <http://www.e-z-mrp.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