[AccessD] Query giving different results each time

Hi Mark

I would split it in two queries and test that.

/gustav


> SELECT 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.profile_cm_seq = A.profile_cm_seq;)) AND 
> ((tblPRS_Pending_PHONE.primary_ind)="y"));