So, I have a query that pull up data based on Criteria on a form.
[A?P?R?]
Criteria: IIf([Forms]![Frm_Report_PayorMix]![FinalDecision]="*",([Referrals].[A?P?R?])<>"F/U",[Forms]![Frm_Report_PayorMix]![FinalDecision])
I thought this will generate a <>"F/U" if the FinalDecision box = * ,otherwise, will just be the value on the FinalDecision Box
SELECT Referrals.ReferralDate, Referrals.[A?P?R?], Referrals.CaseComplete, Referrals.RefType, Referrals.NN, Referrals.[ROC?], Referrals.Patient, Referrals.RefSource, Referrals.Zip, Referrals.Dx, Referrals.Payor, Referrals.InsSpecific, Referrals.[ACO?], Referrals.ExpHHSOC, Referrals.ExpPTEval, Referrals.ID, Referrals.DOB, Referrals.M0102, Referrals.Attending, Referrals.[BSHSIDoc?], Referrals.EnteredBy, Referrals.DeclineReason, Referrals.[SN?], Referrals.[PT?], Referrals.[OT?], Referrals.[ST?], Referrals.OtherServices, Referrals.RefProcessed, Referrals.[Bundled?]
FROM Referrals
WHERE (((Referrals.[A?P?R?])=IIf([Forms]![Frm_Report_PayorMix]![FinalDecision]="*",([Referrals].[A?P?R?])<>"F/U",[Forms]![Frm_Report_PayorMix]![FinalDecision])) AND ((Referrals.RefType) Like [Forms]![Frm_Report_PayorMix]![OtherRef]) AND ((Referrals.[ROC?])=False) AND ((Referrals.ExpHHSOC)>=[Forms]![Frm_Report_PayorMix]![From] And (Referrals.ExpHHSOC)<DateAdd("d",1,[Forms]![Frm_Report_PayorMix]![Thru])))
ORDER BY Referrals.[A?P?R?], Referrals.Patient;