Multiple find criteria
Please help me figure this out. I have a database that I schedule my photographers to photograph schools. I have 21 photographers who need to know where they have to be on any particular day. Here is some of the fields I have:
Main_Retake_Cal (This is a calculation field for fining Main shoot or Retake purposes)
I wrote a script that will find the schools that their retake date has be scheduled and confirmed and the script will no longer show the original shoot on the list. (Awesome if the shoot has happened already)
However I need it to show the shoot date as well as retake date if the shoot date has not yet happened.
This is my script:
Enter Find Mode [Restore]