Nevermind, scratch the below!
Upon further investigation I discovered these gems:
All fields in the SELECT field list must either be included in the GROUP BY clause or be included as arguments to an SQL aggregate function.
groupfieldlist - The names of up to 10 fields used to group records. The order of the field names in groupfieldlist determines the grouping levels from the highest to the lowest level of grouping.
So, I still cant group by just one field! Well, here is an example of what im working with. Maybe you will see a solution that I dont:
[/code]
SELECT [ACT].[Create Date], [ACT].[Company], [ACT].[Record Creator], Qualified() AS Qualified, [ACT].[Lead Source]
FROM ACT LEFT JOIN [Web And Referral Leads] ON [ACT].[Company]=[Web And Referral Leads].[Company]
WHERE ((([ACT].[Create Date])>#12/31/2001# And ([ACT].[Create Date])<#12/31/2002#) And [ACT].[Record Creator]<>"Barry Bowman" And [ACT].[Record Creator]<>"Jorge Yant" And ([ACT].[Company]) Is Not Null);
I would like to remove ONLY duplicate [ACT].[Company] instances.
Thanks again everyone,
Derek Basch