SQL- fejl 80040e14

Fejlen:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'bruger' as part of an aggregate function.

/3SEM04/vis_forum_oversigt.asp, line 63


Koden/SQL (line 63):

rs = conn.Execute("SELECT  Max(ID), bruger, emne, datoogtid FROM forum GROUP BY emne ORDER BY Max(ID) DESC;");