 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / July 2006Need the following Running total to group by [Control]
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) 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 >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) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.