D
dje
I have searched the discussion group but havent found a way to make my query
calculate a running total.
I have a query [MTM App Buyer] which is made up of:
Field MyDate Tot Bal USD
Table Daily Price Non Cash Trans
Total Group By Sum
Sort Ascending
The first selection shows dates and the second selection shows daily
movement of values as I buy and sell an asset. I want a third column which
shows running balance of those values by date i.e.
1/1/08 100 100
2/1/08 25 125
3/1/08 -50 75 etc
I know I can do this in a report but I want to use the running balance in a
union query which aggregates 6 or 7 similar running balances to come up with
an overall running balance.
I have become aware of the Dsum expression but cant seem to get the syntax
to work. Can anyone help me overcome this?
Thanks
calculate a running total.
I have a query [MTM App Buyer] which is made up of:
Field MyDate Tot Bal USD
Table Daily Price Non Cash Trans
Total Group By Sum
Sort Ascending
The first selection shows dates and the second selection shows daily
movement of values as I buy and sell an asset. I want a third column which
shows running balance of those values by date i.e.
1/1/08 100 100
2/1/08 25 125
3/1/08 -50 75 etc
I know I can do this in a report but I want to use the running balance in a
union query which aggregates 6 or 7 similar running balances to come up with
an overall running balance.
I have become aware of the Dsum expression but cant seem to get the syntax
to work. Can anyone help me overcome this?
Thanks