Quarter Total

[JoeC]

I have a database with dept, date, amount. I want to
create a report with the format

Dept Name Quarter Amount Database Total
DHR $5000.00 $1276500.00

Where the Database total with be the total for the dept.
from the whole table and on the same detail line. Please
help. Thanks.

 

[Marshall Barton]

I have a database with dept, date, amount. I want to
create a report with the format

Dept Name Quarter Amount Database Total
DHR $5000.00 $1276500.00

Where the Database total with be the total for the dept.
from the whole table and on the same detail line.

Seems like an odd thing to do, but you can set the db total
text box to an expression like:

=DSum("amount", "thetable", "dept = """ & dept & """")