>ORDER BY must be the last clause

That gives me the following:

Result: Not a group by expression

Query: Select course,subject,held,course_date,idtraining,count(training.course) from training group by training.course order by training.course

This is the same situation I was in previously. ;-(

Best.

Matt.