Create a form to enter report criteria example doesn't work?

D

Darock

i think this is what i want to use but i am unsure. Maybe there is a better
way. I need to use a DSum statement with criteria in a report to calculate a
running total of donations based on a fund name. for example a total amount
donated to a political campaign, but the database tracks more than one
politician, yet they are all members of the same party. So i need to track a
sum donated to Mr. Smith, and be able to seperate the amounts. I have this
working with a DSum that i manually enter the criteria, what i want to do is
have the criteria dynamic so that it is asked at the opening of the report.

Any ideas?
 
S

Steve Schapel

Darock,

Would it serve your purposes to use the report's Sorting & Grouping to
put in a Group Footer based on the candidate/fund, and then you can just
use the Sum() function in a textbox in this footer to see the total for
each/any fund?
 
Top