DB2, MySQL Programmer needs Access Answer

[cgaccess]

OK, I'm sure you guys have heard this a million times, but here goes.

I need SUBTOTALS and a GRAND TOTAL in a QUERY, not a report, not a form. My users are non-computer-literate.

I need to create a QUERY whose results will be exported to Excel via File > Export.... The Excel spreadsheet must look like this:

Mr. John Smith 10 American Way Item-A $30.00
Mr. Dave Doe 20 West Wing St. Item-A $25.00
Ms. Anne Bullock 15 Main Street Item-A $50.00
SUBTOTAL FOR ITEM-A: $105.00

Mrs. Rita Left 100 Wayne Way Item-B $10.00
Mrs. Anne Right 200 West Street Item-B $10.00
Mr. Henry Miller 150 Main Street Item-B $10.00
SUBTOTAL FOR ITEM-B: $30.00

GRAND TOTAL: $135.00



Eventually I plan to use VBA in Excel to make this happen, but I'm not a VB programmer so I'm a little out of my element. I just need something FAST right now.

[pbaldy]

One way

http://www.rogersaccesslibrary.com/f...-c619a955.html