Hi,

I have data that is being retrieved like "Table A" below and want to put it into a Cross-Tab.  There could be any number of Dates so that's why I'm using the Cross-Tab.  I would like the Cross-Tab to look like Cross-Tab Results (below) but can't seem to figure out how to do it.  I'm guessing that it can be done but none of the books I've looked through are showing what I would like.

Any ideas, help and/or suggestions will be greatly appreciated.

Thanks in advance.

Ron

Table A

Date		Customer		Product	Amt
4/23/2010		Acme		A1	$200
4/23/2010		Acme		B2	$100
4/23/2010		Smithco		A1	$200
4/23/2010		Smithco		B2	$200
4/30/2010		Acme		A1	$75
4/30/2010		Acme		B2	$100
4/30/2010		Smithco		A1	$200
4/30/2010		Smithco		B2	$75
5/7/2010		Acme		A1	$150
5/7/2010		Acme		B2	$200
5/7/2010		Smithco		A1	$150
5/7/2010		Smithco		B2	$150
5/14/2010		Acme		A1	$100
5/14/2010		Acme		B2	$200
5/14/2010		Smithco		A1	$300
5/14/2010		Smithco		B2	$100

Cross-Tab Results

Customer	Product	5/14/2010	5/7/2010	4/30/2010	4/23/2010
Acme	A1	$100	$150	$75	$200
	B2	$200	$200	$100	$100
Smithco	A1	$300	$150	$200	$200
	B2	$100	$150	$75	$200