Challenging query....

[Jeff McKeon]

I have a table that contains customer revenue information.

REVENUE TABLE:

Date, customer name, CustomerID, revenue, quantity

I need to create a query that will produce the following result


Year, Month, Customer1_rev, customer2_REV, customer3_rev, etc...
2002, 01, 	0,	$30.00,	$15.00
2002, 02, 	$25.00,	$50.00,	$10.00
2002, 03, 	$10.00,	$25.00,	$40.00
Etc..

Can this be done with a single query???

Jeff