I understand the principal in using the dsum function, just not how to apply it.
I have a form (address). I wish to put a field, in currencvy format, in this form from a query from a subform (finance). Each record on the form has its own ID (AddressID) which is also used on the query. There are multiple records on the query against each ID. I would like to sum these records for one field in the query (payment). Can anyone tell me the formula to use with dsum on the form.
Many thanks
John
I have a form (address). I wish to put a field, in currencvy format, in this form from a query from a subform (finance). Each record on the form has its own ID (AddressID) which is also used on the query. There are multiple records on the query against each ID. I would like to sum these records for one field in the query (payment). Can anyone tell me the formula to use with dsum on the form.
Many thanks
John