Drew Jensen wrote:
So - change the query to
SELECT Count(*) AS "Count" FROM "MainBank"
ORDER BY ( SUBSTR( "QuestionCode", 1, 9 ) )
With the query designer in SQL view click on the 'Run SQL direct' tool
button ( the letters SQL with a green checkmark ) and it will run fine.
errrr - that is of course:
SELECT Count(*) AS "Count" FROM "MainBank"
GROUP BY ( SUBSTR( "QuestionCode", 1, 9 ) )
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
