table = cash disbursment
id = auto number
CAN NOT GROUP ON FIELDS SELECTED WITH '*'.
I want to get a running total out of subtotal, but I keep getting an error when I try to run it, the error:
SELECT [cash disbursment].id AS idalias, Sum([cash disbursment].SubTotal) AS SumOfSubTotal, Format(DSum("subtotal","cash disbursment","[id]<=" & [idalias] & ""),"$00,000.00") AS RunTot, *
FROM [cash disbursment];

ALL help will be appreciated.

table = cash disbursment
id = auto number
I want to get a running total out of subtotal, but I keep getting an error when I try to run it, the error: CAN NOT GROUP ON FIELDS SELECTED WITH '*'.

SELECT [cash disbursment].id AS idalias, Sum([cash disbursment].SubTotal) AS SumOfSubTotal, Format(DSum("subtotal","cash disbursment","[id]<=" & [idalias] & ""),"$00,000.00") AS RunTot, *
FROM [cash disbursment];

ALL help will be appreciated.