AnsweredAssumed Answered

Multiple find criteria

Question asked by MehrdadBastan on Oct 19, 2011
Latest reply on Oct 21, 2011 by philmodjunk

Title

Multiple find criteria

Post

Hi Everyone
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:
School name
Shoot date
retake date
photographers
Confirmed
Tentative
Main_Retake_Cal (This is a calculation field for fining Main shoot or Retake purposes)
Start_date
End_Date
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]
Set Filed[School_Info::Main_Retake_Cal;School_Info::Start_date::&...&School_Info::End_Date]
Perform Find[]
Please help
Thanks

Outcomes