Query is giving duplicates, How to resolve.

Hi All,


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

Table1 Invoice No.
code name sec
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, LLCddddddddddddddddddddddd dh 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.:banghead:


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

Patient: Doctor, when I do this it hurts.

Doctor: My prescription is that you shouldnt do that.

I mean, do you need the Name field? (Poor choice for a field name by the way, its a reserved word and makes code and queries harder to write). If you want those two records to group together, don't bring in the Name field.

Do you need the Name value in the query, if so, which one and why?

I am very sorry, Yes I need Name field, But I tried too much to edit this thread in this forum, and not able to give you the tables. But here is the another in another forum about this.

accessforums.net/queries/how-achieve-result-without-duplicates-53059.html