[AccessD] Export to multiple Excel sheets

You all have been so helpful to me on my projects - I hope one day I can be 
on the helping end instead of always asking for help.

I've got a table with about 10 fields, 2 of which are Dept and Center.  Any 
given Dept might have multiple Centers.  I'm exporting query results to 
Excel spreadsheets, but I haven't been able to figure out how to have a Dept 
with multiple Centers export to one Excel file with a separate sheet for 
each Center.  Can anyone give me some ideas on how to accomplish this?

Thanks,
Gina

_________________________________________________________________
Wonder if the latest virus has gotten to your computer? Find out. Run the 
FREE McAfee online computer scan! 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963