Create Query Combining record group by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
ohh, no need for response, i already find examples,and have worked it
out,very good examples,Thanks!
 
Back
Top