Create Query Combining record group by date

[Guest]

Hello,
I want to create a query,below is the example:
Table:
Date Model Qty
3/6 A 10
3/6 B 10
3/6 C 10
3/7 A 10
3/7 B 10
and query result should be:
Date Mode Qty
3/6 A&BAC 10&10&10
3/7 A&B 10&10

So who could kindly give me this answer, i really don't know how to do?thank
you so much!

 

[Guest]

ohh, no need for response, i already find examples,and have worked it
out,very good examples,Thanks!