AnsweredAssumed Answered

Assistance with distinct query

Question asked by Gasar1375 on Feb 10, 2016
Latest reply on Feb 10, 2016 by siplus

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.