Hi.
I have a table that records material received. The main fields are MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status. Any material can come any number of times in a month.
Each time it comes, it is stored as a record. Example :
MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status
M121, Steel rods,12-sep-17,14-Sep-17,Returned to supplier, Material defective
M121,Steel rods,17-Sep-17,18-Sep-17,Sent to Lab, Material satisfactory
M121,Steel rods,20-Sep-17,22-Sep-17,Sent to Foundry, Material as per specs
At any given time, I need a query that shows material received, date wise grouped on MatID with the Status column showing the entire history of material received, as follows:
M121,Steel Rods, Recd on 12-sep-17 and Returned to supplier on 14-Sep-17, as Material defective
Recd on 17-sep-17 and Sent to Lab on 18-Sep-17, as Material satisfactory
.... and so on
What I mean is, the Status column in query result must contain entire history as text info string. Is this possible ?
Any help appreciated.
I have a table that records material received. The main fields are MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status. Any material can come any number of times in a month.
Each time it comes, it is stored as a record. Example :
MatID, MatName, DateRecd, ClrdOn, ClrdTo, Status
M121, Steel rods,12-sep-17,14-Sep-17,Returned to supplier, Material defective
M121,Steel rods,17-Sep-17,18-Sep-17,Sent to Lab, Material satisfactory
M121,Steel rods,20-Sep-17,22-Sep-17,Sent to Foundry, Material as per specs
At any given time, I need a query that shows material received, date wise grouped on MatID with the Status column showing the entire history of material received, as follows:
M121,Steel Rods, Recd on 12-sep-17 and Returned to supplier on 14-Sep-17, as Material defective
Recd on 17-sep-17 and Sent to Lab on 18-Sep-17, as Material satisfactory
.... and so on
What I mean is, the Status column in query result must contain entire history as text info string. Is this possible ?
Any help appreciated.