Group By Query

[JJT]

I have a table in case number order where many of the records have duplicate case numbers. I was recently told that a Group By query would enable me to eliminate duplicate records from my table.

Can you show me the format ?

Thanks

 

[LQ]

Grouping the case numbers will not remove duplicates from the original table. If what you are needing is to run a query from the table, and want to group the case numbers (so that you can get a sum, average, count or something like that), then you would click on the Totals tool (it's on the toolbar in query view -- looks like a Sigma) and choose "Group By" in the particular field that you want to group.

HTH

 

[lscheer]

Also, the group by function won't work if you include other fields and the data in them is unique. It only groups records where data in all fields is the same.

To remove duplicates from a table, you need to use a Find Duplicates query (you can use a query wizard) to find them, and then, if it's feasible, you can delete them from there. A word of caution: you will get all of your duplicate records, so be sure not to delete everything in the query, just all but one record.

 

[arickards]

JJT,
I think your best alternative would be my suggestion on your original post of 9-17.
If your not sure how I can give more detail.