1 Reply Latest reply on May 11, 2015 4:27 PM by philmodjunk

    ExecuteSql

    MT_2

      Title

      ExecuteSql

      Post

      Hi,

       

      I have a table called "Product" and a field called "client id#" I am trying to see how many unique client ids are on a layout, I have created a calculation field as below and inserted the field onto my layout but I just get ? in the field. 

       

      Can anyone help, does the below look correct?!?

       

      ExecuteSQL ( "select count (Distinct client id#) from product" ; "";"" )