AnsweredAssumed Answered

Create Calculation Field Using Executesql

Question asked by LauraW on Feb 24, 2015
Latest reply on Mar 4, 2015 by LauraW

Title

Create Calculation Field Using Executesql

Post

Working on setting up a basic database for a small company with very little technical knowledge.  Is it possible to set a calculation field with the following:  ExecuteSQL ("SELECT COUNT(DISTINCT fieldname)
WHERE FoundSet;" ; "" ; "")

The current field I have set up with this calculation returns a ?

 

Outcomes