G
Guest
Hi there,
I have a sub form on a form that is pulling data from a query. I want to
have a running sum on this subform (which is a continuous form) and used the
formula below. The record source for the subform is Query1.
=DSum("[Amount]","[Query1]","[UniqueField] <=" & "[UniqueField]")
I'm getting the sum of the entire query for each record and I'm not sure
what is wrong with my syntax.
Could someone help me out?
Thanks in advance!!
I have a sub form on a form that is pulling data from a query. I want to
have a running sum on this subform (which is a continuous form) and used the
formula below. The record source for the subform is Query1.
=DSum("[Amount]","[Query1]","[UniqueField] <=" & "[UniqueField]")
I'm getting the sum of the entire query for each record and I'm not sure
what is wrong with my syntax.
Could someone help me out?
Thanks in advance!!