Export to excel in different tabs depending on criteria

Hi,

I have a query called "CVR Movement", this contains various transactions
against various [JOB REF] codes. I want to export the data to Excel and would
like the data put into different tabs on the file which is retrieved from the
[JOB REF] field. Can this be done in code? If so, where does this need to go?
I have Office 2000 if it makes a difference at all.

Thanks
--
K Hogwood-Thompson
.

Loading