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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top