I have a query question. I need to create a report, I have some records that haves Rejected and some records that have Returned, both are set as "Y" in the table also have the rejected date and returned date, user can select either Rejected or Returned but can't select both. Now my question is how do I pull all the records that either Rejected or Returned? Better I user the Date or "Y"? Here is the field that I tried to pull the number for both but it's incorrect.
Rej/Ret: IIf(Not IsNull([PDREJDATE]),[PDREJDATE],IIf(Not IsNull([PDRETURNEDDATE]),[PDRETURNEDDATE]))