[AccessD] Query giving different results each time

Lets try a different route. Please explain what you have and what result you want.

Scott Marcus

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Wednesday, July 28, 2004 9:27 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Query giving different results each time


Scott,

Thanks for the feedback...but the results of this sql are also 
inconsistant...I ran it 3 times...and got 3 different results...the reslults 
are typically close...for the last 3 tries...it returned 2365, 2369 and 
2375...without changing anything...just re-running the sql???

I fell very confused...lol

Any ideas?

Thanks,

Mark


>From: "Scott Marcus" <marcus at tsstech.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Query giving different results each time
>Date: Wed, 28 Jul 2004 09:12:00 -0400
>
>Mark,
>
>Do you try the following to see if it fixes your problem?
>
>SELECT B.profile_cm_seq,
>        B.effdt,
>        B.bo_id,
>        B.primary_ind,
>        B.phone
>FROM tblPRS_Pending_PHONE B
>WHERE (B.effdt=(SELECT Max(A.effdt)
>                 FROM tblPRS_Pending_PHONE A
>                 WHERE B.bo_id = A.bo_id
>                       AND
>                       B.profile_cm_seq = A.profile_cm_seq))
>       AND
>       B.primary_ind="y";
>
>
>Scott Marcus
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Discover the best of the best at MSN Luxury Living. http://lexus.msn.com/

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