Use IIf() function.
IIf(Role="A", A_Due_Date, B_Due_Date)
But if a record can have only one role, why have two Due Date fields?
Use IIf() function.
IIf(Role="A", A_Due_Date, B_Due_Date)
But if a record can have only one role, why have two Due Date fields?
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote