S
Spanky
I am having a really hard time trying to get my DSum update query to
work. What I'm trying to accomplish is a running total of claims
across time for claimants. The fields I'm using in my update query
are [CCC] a text field that identifies a claimant, [SumOfPAID_BY_US] a
number that is monthly summation of all claims. I have created a new
field called [Running Total Claims] a number that will be updated by
my query.
I have a few questions
A. Is Dsum the best function to use for a running total across time
B. My current query doen'st account for time: UPDATE [tbl_Over Spec
Deduct] SET [tbl_Over Spec Deduct].[Running Total Claims] =
DSum("[tbl_Over Spec Deduct]![SumOfPAID_BY_US]","tbl_Over Spec
Deduct"," [tbl_Over Spec Deduct]![CCC]=" & [CCC]);
I have a month field in my table, how can I create a running total
based on [CCC] and my month field?
C. Any ideas as to why this my cause a Type conversion failure
Thanks so much
David Hallidy
work. What I'm trying to accomplish is a running total of claims
across time for claimants. The fields I'm using in my update query
are [CCC] a text field that identifies a claimant, [SumOfPAID_BY_US] a
number that is monthly summation of all claims. I have created a new
field called [Running Total Claims] a number that will be updated by
my query.
I have a few questions
A. Is Dsum the best function to use for a running total across time
B. My current query doen'st account for time: UPDATE [tbl_Over Spec
Deduct] SET [tbl_Over Spec Deduct].[Running Total Claims] =
DSum("[tbl_Over Spec Deduct]![SumOfPAID_BY_US]","tbl_Over Spec
Deduct"," [tbl_Over Spec Deduct]![CCC]=" & [CCC]);
I have a month field in my table, how can I create a running total
based on [CCC] and my month field?
C. Any ideas as to why this my cause a Type conversion failure
Thanks so much
David Hallidy