DSum (1 Viewer)

VSolano · Feb 21, 2017

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])

Beetle · Feb 21, 2017

If the data types of EmployeeID and BenefitsID are numeric, then;

Code:

DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=" & [tbpayrolldeduction]![EmployeeID] & " And [BenefitsID] =" & [tbBenefits]![BenefitsID])

If the data types are text, then;

Code:

DSumAmt: DSum("[deductionamount]","tbpayrolldeduction","[employeeID]=[COLOR="Red"]'[/COLOR]" & [tbpayrolldeduction]![EmployeeID] & "[COLOR="red"]'[/COLOR] And [BenefitsID] =[COLOR="Red"]'[/COLOR]" & [tbBenefits]![BenefitsID] & "[COLOR="red"]'[/COLOR]")

Note the single quote delimiters that are added (highlighted in red)

VSolano · Feb 22, 2017

Thanks for your precise response.

DSum (1 Viewer)

VSolano

Registered User.

Beetle

Duly Registered Boozer

VSolano

Registered User.

Similar threads

Users who are viewing this thread