AnsweredAssumed Answered

ExecuteSql

Question asked by MT_2 on May 9, 2015
Latest reply on May 11, 2015 by philmodjunk

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" ; "";"" )

Outcomes