Hi.
Is it possible to get a query result (grouped) as follows: ?
Itemcode,Itemname,QtyOrdered,DateOrdered ( are the fields)
S100, Shoes,150, 12-jun-16
.....................200, 14-may-17
.....................300, 22-sep-17
.....................410,05-oct-17
(The dots are just to indicate place as it gets left justified when I post)
S200, Belts, 50, 15-mar-13
90, 30-apr-15
70, 16-jul-17
45, 06-aug-17
I thinks it's possible in a report. But I need it in a query ?
Any chance ??
Is it possible to get a query result (grouped) as follows: ?
Itemcode,Itemname,QtyOrdered,DateOrdered ( are the fields)
S100, Shoes,150, 12-jun-16
.....................200, 14-may-17
.....................300, 22-sep-17
.....................410,05-oct-17
(The dots are just to indicate place as it gets left justified when I post)
S200, Belts, 50, 15-mar-13
90, 30-apr-15
70, 16-jul-17
45, 06-aug-17
I thinks it's possible in a report. But I need it in a query ?
Any chance ??