10 Replies Latest reply on Feb 10, 2016 11:27 AM by siplus

    Assistance with distinct query

    Gasar1375

      Hello all,

       

      I have a simple query ExecuteSQL ("SELECT COUNT (Distinct Opus) FROM BigBase" ; "" ; "") saved as an unstored calculated number field. This returns the iterations of Opus in my DB, which 19, that is I have 19 different values for Opus. What I want instead is for my field to return the number of times each value in Opus appears. How can I go about achieving this? Thank you.