[AccessD] Query giving different results each time

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Jul 26 15:04:02 CDT 2004


Hi Mark:

If you want to update anything in a table you have to use the 'Update' sql
string. Just go into the query form and select query type Update. It should
be easy to proceed from there.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
Sent: Monday, July 26, 2004 12:35 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Query giving different results each time


Hello All,

In A97 I am running a local query...I couldn't get the results I wanted...so
I kept treaking my criteria...but then I realized...that if I didn'tchange
anything...I would get slightly different results...each time I ran it.  It
would omit 1-5 rows...but not the same ones.

Desperately confused...any insight?

Thanks,

Mark A. Matte

SQL:

SELECT tblPRS_Pending_PHONE.case_id, tblPRS_Pending_PHONE.profile_cm_seq,
tblPRS_Pending_PHONE.effdt, tblPRS_Pending_PHONE.bo_id,
tblPRS_Pending_PHONE.primary_ind, tblPRS_Pending_PHONE.phone
FROM tblPRS_Pending_PHONE
WHERE (((tblPRS_Pending_PHONE.effdt)=(SELECT Max(A.effdt) AS MaxOfeffdt
FROM tblPRS_Pending_PHONE A
WHERE  tblPRS_Pending_PHONE.bo_id =  A.bo_id;)) AND
((tblPRS_Pending_PHONE.primary_ind)="y"));

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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




More information about the AccessD mailing list