How to achieve result without duplicates

[punna111]

Hi All,


Here is the my Table: It consists 8 records (including one duplicate record based on Invoice No.)

Invoice No.	code	name	Section	amt
56577	FG- 0316	ABC Transcription Services, Inc.	cw	8993
56578	FG- 0317	ABJT Structural Engineers, LLC	tw	9003
56579	FG- 0318	Absolute Staffing Solutions, Inc.	tw	9004
56580	FG- 0319	Academic Network, LLC	tw	9005
56568	FG- 0415	9th Dimension Cleaning & Painting,	rh	8994
56575	FG- 0515	ABC LLC	dv	2000
56575	FG- 0516	ABC	cw	8991
56576	FG- 0616	Abbott & Associates Professional Placement, Inc.	cw	8992

When i do a query with Invoice No., amt fields I am Getting 7 records, and for amount field I am doing sum. That is the result I am looking.

But including Name field. When I include Name field it is giving 8 records hence 56575 invoice No. has two different names.
How can I achieve this as shown below: Below is I want. It's allowed to give any name- ABC LLc or ABC for 56575 Invoice No.

I am unable to do this query and struggling from past 2 weeks. Let me know if you need additional details. I tried Many ways.

Is this is not possible in MS Access?. Please help me, Thanks.

Invoice No.	name	amt
56577	ABC Transcription Services, Inc.	8993
56578	ABJT Structural Engineers, LLC	9003
56579	Absolute Staffing Solutions, Inc.	9004
56580	Academic Network, LLC	9005
56568	9th Dimension Cleaning & Painting,	8994
56575	ABC	10991
56576	Abbott & Associates Professional Placement, Inc.	8992

[pbaldy]

Change Group By to Min, Max or whatever on the name field.

[CJ_London]

duplicate post here

http://www.access-programmers.co.uk/...d.php?t=278262

[punna111]

Thank you very much Paul.

To get the quick response I posted in multiple forums. But still all are redirected here for tables.

[pbaldy]

Happy to help!