Setting up query with multiple data

I want to sort by the "C04" part of the records. The data connected to the
Datestamp and DateScanned can be a string of entries or just one, with the
"C*" record in it.
Example
Datestamp 11:00 DateScanned 08/10/05 Items scanned C04, 3333, 222, and 888
Datestamp 12:00 DateScanned 08/10/05 Items scanned C03, 3030, and 202
Datestamp 12:01 DateScanned 08/10/05 Items scanned 1010, and C04
Datestamp 1:00 DateScanned 08/10/05 Items scanned 1111, C04, and 20
Datestamp 1:20 DateScannec 08/10/05 Items scanned C40, 77777, and 15
I am not sure what other information is required to get this to work.
but in this example, the query should show a date of 08/10/05; C04, with the
list of Items scanned; 3333,222,888,1010,1111,20,77777 and 15.



.

Loading