problem with 'Group By' clause

[piotr]

Hi,

When I execute a query:

"SELECT id, name, date FROM table GROUP BY name, date;"

This creates error :
"You tried to execute a query that doesn't include the specified expression
'id' as part of an aggregate function"

The point is I want to show 'id' field without including it in GROUP BY
clause ( I want to find records with the same 'name' and 'date' fields and
to show their 'id')
What query should I use?

Regards
Piotr

 

[Lynn Trapp]

Try this:

SELECT Distinct id, name, date
FROM YourTable;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html