Need the following Running total to group by [Control]

[Greg]

I have the following running total working in a query, only problem is I
need it to total only the group from the Control field selection.

RunTotal: Format(DSum("Minutes","subtable","[Control]<=" & [ContAlias] & "
"),"0000.0",0)

 

[Michel Walsh]

Hi,



RunTotal: Format(DSum("Minutes","subtable","Selection=
Forms!YourFormNameHere!Selection AND [Control]<=" & [ContAlias] & "
"),"0000.0",0)




where I assumed your impled control (in the form) and field (in the table)
are both called Selection.


Hoping it may help,
Vanderghast, Access MVP