The query is actually embedded in this archaic FoxPro app and there's no way
for me to alter it. So, what I do every morning is hit a key which in turn
launches an internal proc that finally kicks back this raw data.

I then spend about 10 minutes and sort it, remove certain records, archive
other records, re-sort the data, stick a header and footer in, then tweak
the formulas a bit. It's really not that hard to do manually, but I'm lazy!

There's so many mundane little steps that I have to go through, that its
really hard for anyone to "picture" the problem. More reason to macro it
out.

You're right though, it would be so much easier if I could just type up my
own SQL.

Mein deutsch ist leider nicht zu gut. Ich habe Deutsch 4 Jahre in der
Schule studiert. Meine Frau hat Deutschland 2mal besucht aber ich hab' die
Chance noch nicht. Sie kann gut auf deutsch sprechen. Mindestens, besser
als ich.

Dan
"chris" wrote in message
oups.com...
Dan,
you've written nothing about the dbquery but could you not save the
first two steps by including a where condition into the sql (something
like WHERE (Vendor<'xxx') AND (Total Cell<0.0)?
You can also subtotal by day, which should make the last step
superfluous.
Not sure if this helps, but have slight difficulties to picture the
problem. You seem to be german speaking - if it helps, write me in
german