[thelist] Understanding an SQL Problem

[Rob Smith]

Hi list,

Here's my SQL Query:
SELECT DateAccessed, TimeAccessed FROM IntranetLog where DateAccessed =
'1/6/03' Group By TimeAccessed Order by TimeAccessed

Here's the error I'm getting:
Column 'IntranetLog.DateAccessed' is invalid in the select list because it
is not contained in either an aggregate function or the GROUP BY clause.

I have no idea how to resolve this because the error message is not helpful
as usual.

Thanks for your help,

Rob Smith