I have an unstored calculation field that uses the following:
ExecuteSQL ("SELECT COUNT (DISTINCT summary_listOf_idProject) FROM Layout » Time" ; "" ; "")
The field is a list which may or maynot have different values. The result displayed in the field is ?, which I assume means that the SQL is not correct syntax. What am I missing?
"summary_list" is the field containing the list of values and "Time" is the table name.