[dba-SQLServer][AccessD]

To all,
I have a access query which will contain a range of dates and a shift number (1,2,3), which will normally have data similar to the following:
Date            Shift            Quantity
26/08/03         1                 34
26/08/03         1                 32
26/08/03         2                 12
26/08/03         3                 56
26/08/03         3                 43
I need to export this query out to Excel but stop after each shift number finishes and add sub-totals into the Excel sheet like so :
Date            Shift            Quantity
26/08/03         1                 34
26/08/03         1                 32
                  Sub-Total Qty   66
26/08/03         2                 12
                  Sub-Total Qty   12
26/08/03         3                 56
26/08/03         3                 43
                   Sub-Total Qty   99
Anyone know a way that this can be achieved........
Thanks in advance for any help.....

Paul 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030827/33b24b83/attachment-0001.html>
-------------- next part --------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com