Running Total In Subform with criteria

[buzzboychicago]

Hi, I have an unbound field in a subform header that I want to have a running total in.

Most people suggest using
=Sum([Quantity] in the field source

But, I'd only like the to be added if another field in that subform meets a certain criteria.

Does anyone know a good way to go about this.

If you are suggesting I use SQL stuff, I don't really understand how to 1) reference the subform in SQL and 2) how to send the final value of the recordset I create to the unbound field.

Lemme know. Thanks ahead of time for your help!

 

[PHV]

Take a look at the DSum function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[buzzboychicago]

I have tried just now...I can't get the syntax right.

DSum(expr, domain, [criteria])

(I think it would work if it weren't a subform. How do I let it know that were talking about the subform and not make access look for the total in a form

I tried various methods...

DSum("[CallQuantity]", [CallTableSubform], "[CallType]= 'Ben'")

as well as being really thorough and typing

DSum("[CallQuantity]","Forms![CustomerBracket]![CallTableSubform]","Forms![CustomerBracket]![CallTableSubform].Form![CallType] = 'Ben'")

I'm also trying to place it in the on current event of the subform.

 

[PHV]

The second argument must be the Query/Table name.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244