Search results
-
A
Choose between 2 columns based on another field in query
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...