Item Number

[capsula4]

Hi!

I have a query like this

ItemNumber | Invoice | Code
1 | 404 | 02
2 | 404 | 04
1 | 406 | 01
2 | 406 | 09
3 | 406 | A9
1 | 407 | 01

My question is, how can I achieve the ItemNumber thing? the idea is that counts the quantity of items per invoice... any idea?

I know how to make this on reports, tho I need it for a QUERY

 

[srbooth]

You could drop the Code Field and used Group by on the Invoice field and Sum on the Item field

 

[capsula4]

You could drop the Code Field and used Group by on the Invoice field and Sum on the Item field

The fact is that I need a view like the previous one to interact with another program which I can't modify. I have to do it that way, there is no other option... I guess I'll have to make a VBA module for that?