VB6 Data Report Grouping

I have a vb6 application connecting to an Access 2000 database. a datareport based on an SQL that is grouped returns the following error when opened.

Invalid SQL statement; expected ‘DELETE’, ‘INSERT’, ‘PROCEDURE’, ‘SELECT’, or ‘UPDATE’.

The SQL works fine in the design window so it would appear to be something to do with the grouping which is done from within the command properties Grouping section.

Please help ASAP

Thanks

Brian