Very Computer

What is the structure of the table?

Is there a date field? (I'm assuming so)

dtVar="4/../2003"
qbe=query

  table.db  | driver   | datefield  | commissions               |
            | check    | ~dtVar     | calc sum as theirmoney    |

endquery
qbe.executeqbe("newtable.db")

This gets you a summary for a single month.

But if you want a report with a summary showing EACH of SEVERAL months, you
need to have a field that has JUST the month (numeric or alpha, your
preference).

Then you can summarize on that field with query or report.

--
--
Tony

"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

Ken wrote,

Quote:> I have a table with daily commissions for each of my drivers. How do I
print
> a report with summarized monthly totals? I tried grouping by month, but it
> still prints each daily total.

If you want monthly totals only by driver,
do you want

Sort #1 , Driver then month
Driver 1
  Jan
  Feb
  Mar

Driver 2
 Jan
 Feb

or

Sort #2 , month then driver
Jan
    Driver 1
    Driver 2

It sounds like you have grouping by month figured out,
but my guess is , you have left the record in the table band, which means it
shows every record in the table.
Eliminate records from the detail table band, and then only the summaries
will print.
This will allow the report to do the summing, and you wont need a summary
query.

Good luck
Robert Wiltshire