Search results

Thank u. Brain fart. I had not even tried including tblB in the query. Simple solution.

tblA with relative fields DateEffective and ActionID(FK) tblB is a reference table with relative fields ActionID(PK), PendingStatus, EffectiveStatus Ive created a query which includes DateEffective and ActionID from tblA, and a calculated field called CurrentStatus. My objective: if...