8 Replies Latest reply on Sep 16, 2014 6:15 AM by BruceHerbach

    One SQL formula works, one doesn't

    rsmellette

      I'm used to GUI SQL from Access, so writing it out is driving me nuts... but...

       

      I managed to make this formula work:

       

      ExecuteSQL ("SELECT SUM (TotalRunTime) FROM Films WHERE FeatureShort = ? AND Consider = ?" ; "" ; ""; "Feature"; "Competition";)

       

      But when I try to add a new field restriction from the Films table, it doesn't.

       

      ExecuteSQL ("SELECT SUM (TotalRunTime) FROM Films WHERE FeatureShort = ? AND Consider = ? AND Round = ?" ; "" ; ""; ""; "Feature"; "Competition";"In")

       

       

      Any help?