I have a table with the following data:

cd nm fy fq amount
1 Joe 2007 2 500
1 Joe 2007 2 425
1 Joe 2007 3 500
2 Jane 2007 1 450
2 Jane 2007 2 500
2 Jane 2007 4 200
2 Jane 2007 4 300

Code:
I would like to have a query produce the following results:

cd	nm	fy	fq1cnt	amount	fq2cnt	amount	fq3cnt	amount	fq4cnt	amount
1	Joe	2007	0	0	2	925	1	500	0	0
2	Jane	2007	1	450	1	500	0	0	2	500
fq is fiscal quarter fq1cnt would be the count of records for fiscal quarter 1 totaling to the amount. Each record in the table is distinguished by another field called BOC which I didn't include in the example.

Can someone point me in the right direction? Thank you!!