AnsweredAssumed Answered


Question asked by fmnoob on Jan 28, 2018
Latest reply on Jan 29, 2018 by beverly

FMP 14


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.