Help with "Group By" using SQL in Access

[jcharbula]

I am using the group by function to remove duplicates based on certain fields. However, I want the Primary Key ID to also be returned
If I add it to the select statement, I have to also add it to the Group By line which messes up the duplicates
So...how can I just view the ID field in my return without making it part of the group by function?

[orange]

Please post the SQL of the query you are using.

[ItsMe]

Sounds like a Normalization issue. If the data is in a Normalized table structure, you should be able to use the GROUP BY clause successfully.

Can you give a brief description, from a business rules perspective, of what you are trying to group. What are these groups going to associate with?