Combine into 1

[EMILYTAN via AccessMonster.com]

I have a raw query which will show the following data:-

PartNumber Invoice Quantity
1115 INV1 10
1115 INV1 10
1112 INV2 10
1112 INV2 2
May i know is there any idea of making it appear only once and sum the
quantity?

example

1115 INV1 20
1112 INV 12

Note: There are many other fields in that grid

 

[Stefan Hoffmann]

hi Emily,

May i know is there any idea of making it appear only once and sum the
quantity?

You need to group your query.

Use the sum button (greek S in the toolbar). You need to select Group By
for the fields which should only appear once. For Quantity you need to
select Sum in field list.



mfG
--> stefan <--