Quarter Total

  • Thread starter Thread starter JoeC
  • Start date Start date
J

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.
 
JoeC said:
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.
Click to expand...


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 & """")
 
Back
Top