Return to FileMaker.com
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" ; "";"" )
ExecuteSQL ( "select count (Distinct \"client id#\") from product" ; "";"" )
Retrieving data ...