[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® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963