If then in Access Query Expression

[gmaxey]

Perfect. Thank you. It is not my database. Trying to help someone else and I am about one step up from a complete novice. But to answer your question (or try)

The record is tracking a process. There are always two parties involved in the process. The first party may play role A or role B. The other party then serves the other role. Both roles in the process have a due date "A_Due_Date" and "B_Due_Date" which will be different.

The query is to return all the records where A_Due_Date is displayed as "Due_Date" if Party 1 is assigned role A or all the records where B_Due_Dsate is displayed as "Due_Date" if Party 1 in assigned role B.

Thank you.