[AccessD] Query giving different results each time

I missed the part of thread where you mentioned a sub-query.  Have you
posted the SQL for this query/subquery?  

Charlotte Foust


-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com] 
Sent: Tuesday, July 27, 2004 7:19 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Query giving different results each time


Yes I tried the compact and repair.  It didn't seem to help.  Each time
I 
run the query...I get different results...is there something about the 
sub-query I am missing?

Thanks,

Mark A. Matte


>From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and 
>problemsolving	<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Query giving different results each time
>Date: Tue, 27 Jul 2004 14:01:07 +1000
>
>On 27 Jul 2004 at 1:45, Mark A Matte wrote:
>
> > Hello All,
> >
> > Thanks for the feedback...but I'm still a  little confused...If I am
>running
> > the same SQL against the same table...back to back...why am I 
> > getting different results?
> >
> >
>A corrupt index? Have you tried a compact and repair?
>
>--
>Lexacorp Ltd
>http://www.lexacorp.com.pg
>Information Technology Consultancy, Software Development,System 
>Support.
>
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from
McAfee(r) 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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