On Wed, 12 Mar 2008 02:32:20 -0400 Drew Jensen <[EMAIL PROTECTED]> dijo:
> 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 ) ) Thanks! That works! I was unaware of the "Run SQL Direct" button, so now I have added another trick to my tools to try when something ought to work but doesn't. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
