Hello:
I new to the database and I am trying to build a query and I can not get this function to work. I will appreciate any help on this function.
DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] And "[BenefitsID] =" & [tbBenefits]![BenefitsID])
I new to the database and I am trying to build a query and I can not get this function to work. I will appreciate any help on this function.
DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] And "[BenefitsID] =" & [tbBenefits]![BenefitsID])