Hi all,
I'm hoping that this question will have a simple answer, I've searched the forum but can't find what I'm looking for (or maybe I have and don't know it). I have a subform from which I want to calculate values into a text box on the main form, to keep a running total of weeks for individuals.
Using the expression builder to just add the fields, I only get the total for the current sub-form record. If another record is added to the subform, the total reverts to zero, and then it takes that record's input as the total. Which makes logical sense.
I think I need to do a 'DSum' from the subform/table, but I'm not sure how to sum for just the current ID/individual. I have tried to bodge it myself with the expression builder, but it tells me that 'the function contains the wrong number of arguments'.
Could anyone help me please? Thanks.
I'm hoping that this question will have a simple answer, I've searched the forum but can't find what I'm looking for (or maybe I have and don't know it). I have a subform from which I want to calculate values into a text box on the main form, to keep a running total of weeks for individuals.
Using the expression builder to just add the fields, I only get the total for the current sub-form record. If another record is added to the subform, the total reverts to zero, and then it takes that record's input as the total. Which makes logical sense.
I think I need to do a 'DSum' from the subform/table, but I'm not sure how to sum for just the current ID/individual. I have tried to bodge it myself with the expression builder, but it tells me that 'the function contains the wrong number of arguments'.
Could anyone help me please? Thanks.