Query result grouped (1 Viewer)

ponneri · Oct 20, 2017

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 ??

plog · Oct 20, 2017

I can't follow what you have and what you want. Can you repost? Give me 2 sets of data:

A. starting data from your data source. Include table and field names and enough data to cover all cases.

B. Expected results of A. Show me the data you hope to end up with when you feed the query the data from A.

Use this format for posting data:

TableNameHere
Field1Name, Field2Name, Field3Name, ...
Steve, 1/12/2017, 91
Dave, 2/13/2017, 88
...

ponneri · Oct 21, 2017

Sure.

Table : OrdersMain
Fields : Slno, Itemcode, Itemname, QtyOrdered, DateOrdered. Status
Records :
1,S100, Shoes,150, 12-jun-16, Delivered fully
3,S100, Shoes,200, 14-may-17, Partially delivered
8,S100,Shoes,300, 22-sep-17, Delivery due
9,S100,Shoes,410, 05-oct-17, Delivery due

and so on.

The result of these records in a query should reflect - only once the Itemcode, Itemname followed by QtyOrdered and DateOrdered one row below another.

Hope it's clear now.

arnelgp · Oct 21, 2017

this can't be done in a simple Query.
you will be needing a function for
the display that you like.
and a form that will host your Query
(preferably a datasheet form so it
mimics the query when it is opened).

plog · Oct 21, 2017

No it's not clear because you didn't provide what I asked. seems you provided A, now please provide B. Don't explain what data you expect the query to return. Show me what data you expect the query to return

ponneri · Oct 22, 2017

I think my initial post covered the expected results of the query.
However, I'll re-frame the question and post again soon.

Thanks.

Query result grouped (1 Viewer)

ponneri

Registered User.

plog

Banishment Pending

ponneri

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

plog

Banishment Pending

ponneri

Registered User.

Similar threads

Users who are viewing this thread