I hope this is the correct forum for this query.

I'm trying to format a simple table/repeat region from a recordset. I have
been trying to GROUP BY (a date variable) so that as the table generates, each
date will be separated/grouped.

I get a mysql error because of the GROUP BY.

I would appreciate any pointers .
Many Thanks