Recent content by jjeong1210

=DSum([Subform].[Form]![Price],[Subform].[Form]![Year],[Subform].[Form]![Year]="2018") I did the above, and it's returning the calculation as #Error still.. Any advice? Thank you

I have data that is labeled as below: Year Service Price 2018 Wash 10 2018 Pick Up 20 2019 Wash 15 2019 Pic Up 23 I want a subtotal/total that will add the total price for year 2018. I have tried =iif([subform].[form]![year]="2018",sum([subform].[form]![price]),)...