Hi there,
I have a Db forms. Main form and subform which has one to many relationship. Where users use to tract the daily expenditure.
What I like to do is that to find by list in budgetcode combo box eg. RAB50, RAB51...RAB60 then show and SUM all the amountUSD in total if one code was used more than one time. I use the following code. In fact, it works fine, however, it shows all available record. Now what I want is to SUM on each single record.
=DSum("AmountUSD","tblSADUPaymentDetails","BudgetCode='RAB53'")
Any comment would appreciate.
Thank you.
I have a Db forms. Main form and subform which has one to many relationship. Where users use to tract the daily expenditure.
What I like to do is that to find by list in budgetcode combo box eg. RAB50, RAB51...RAB60 then show and SUM all the amountUSD in total if one code was used more than one time. I use the following code. In fact, it works fine, however, it shows all available record. Now what I want is to SUM on each single record.
=DSum("AmountUSD","tblSADUPaymentDetails","BudgetCode='RAB53'")
Any comment would appreciate.
Thank you.
