I am getting an error when running the following SQL command in a group:
SELECT TimeDiff((SELECT EndTime FROM Table WHERE Table_ndx = 10),
(SELECT BeginTime FROM Table WHERE Table_ndx = 10))
The message states that " Error executing query: You have an error in your SQL Syntax; check the manual that corresponds to your MySql server version for the right syntax to use near ‘:22:07)’ at line 1"
(The time difference is 22min 07sec)