Using DSUM to get running total on a filtered form

  • Thread starter Thread starter James G
  • Start date Start date
J

James G

I have created an Access form and instead of using filters, I update
the record source with a SQL statement that is dependent on what was
chosen from a series of dropdowns. I finally got this part working,
but I am having trouble trying to get the DSUM function to work. When
I update the record source to filter the form, I only want to get a
sum of the filtered results.

I have a field called "Savings", which is a calculated field in the
query/record source and a field called "ImplementedStatus". In my form
footer, I want to display a sum of the "Savings" field for all the
records where "ImplementedStatus" = "Rejected". The table that all of
the data resides in is "CIP Details".

I currently have text box with the control source set to
"=DSum("Savings","CIP Details",[ImplementedStatus]="Rejected")". This
is giving me the savings from the one field that is set to "Rejected"
but multiplying it time all 45 records that are in the table. I don't
know if I should be using the table name in my DSUM formula, but I
don't know how to specify the record source.

Any help would be greatly appreciated.

Thank you
 
Back
Top