Query to track late shippers - Access 2000

[nowanda]

Howdy!

I have two tables, one contains the expected shipments from our suppliers, the second is the actual received shipments from the same suppliers. We would like to track which suppliers are usually late in shipping their goods by week.

I am able to get the week, qty_expected, qty_received and diff but am having trouble organizing the alphanumerics. I've tried a few crosstab queries - but am having trouble... have a look at the tables in Access and the query I'm hoping to output...

Thanks for anything you can help me with!!

Nowanda

Book1
	A	B	C	D	E	F	G	H
1	SHIPPING_TABLE				RECEIVING_TABLE
2	ID	Week	Supplier	Qty_Shipped	ID	Week	Supplier	Qty_Received
3	1	200336	A	10	1	200336	A	10
4	2	200336	B	5	2	200336	B	5
5	3	200336	C	5	3	200337	A	10
6	4	200337	A	10	4	200337	B	5
7	5	200337	B	5	5	200337	C	5
8	6	200337	D	5	6	200337	D	5
9	7	200337	E	5	7	200337	E	5
10	8	200338	C	5	8	200338	C	5
11	9	200338	D	10	9	200338	D	10
12	10	200338	E	5	10	200338	E	5
13	11	200338	F	5	11	200339	C	5
14	12	200338	G	5	12	200339	D	10
15	13	200339	C	5	13	200339	F	5
16	14	200339	D	10	14	200339	G	5
17
18	LATE_SUPPLIERS_QUERY
19	Week	Shipment_Exp	Qty_Expected	Qty_Received	Diff	Late
20	200336	A,B,C	20	15	-5	C
21	200337	A,B,D,E	25	30	5
22	200338	C,D,E,F,G	30	20	-10	F,G
23	200339	C,D	15	20	5
Sheet2