How to build such a query?

A

Andrej

Hi,
I have many items in a database. And now I sort, filter items and give
them an order /1-last item/, than I sort these ordered items /1-last item/
with others rules and give them another order.

E.g. order surname of items owners with list of item for each owner.
EXAMPLE:
First step-result:===============
No.*ITem*OWner
1*ka*A
2*kc*B
3*ke*C
4*kg*A
5*kr*C
6*kt*A
7*kw*A
Second step-result:=============
OWner*NoOFITems
A*1,4,6,7
B*2
C*3,5
==================
And such report I will now.
E.g. John Doe own items 1,3,5,45,212.

How to do this??
Thanks in advance.
 
A

Andrej

Yes,
I think that this is the right sample. Now I evaluate the method described
there.
Thanks.
 
Top