[AccessD] Query giving different results each time

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