Running total in query not grouping by selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 30 Jul 2006 01:49 GMT

I have the following running total in a query works fine but I need the
Running total to work on the selected Data. When I enter the Control critera
I get the running total of the whole table. I need it to give me a running
total for only the selected records.

Can anyone help with this...

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

Reply to this Message

John Vinson - 30 Jul 2006 02:27 GMT

>I have the following running total in a query works fine but I need the
>Running total to work on the selected Data. When I enter the Control critera
>I get the running total of the whole table. I need it to give me a running
>total for only the selected records.
>
>Can anyone help with this...

You need criteria (in the form of a valid SQL WHERE clause without the
word "WHERE") as the third argument to DSum. You don't say what the
selected data might be, but try something like

RunTotal: Format(DSum("Minutes","subtable","[Control]<=" & [ContAlias]
& " AND <whatever other criteria>"),"0000.0",0)

John W. Vinson[MVP]

Reply to this Message