DSum with multiple criteria

[UT227]

I need to get a sum from a query using 3 criteria. Using only one works great. =Nz(DSum("LeaveHours","qrySchLeaveDates","Employee sID=" & [cboEmployee]))


I need also to qualify it with [WorkLeaveID]=5 and also with [Finalized]=False. I'm not sure how to go about doing this. I tried this. =Nz(DSum("LeaveHours","qrySchLeaveDates","Employee sID=" & [cboEmployee] and WorkLeave=5 and Finalized=False))
It gave me nothing. How do I do this?

[xps35]

Try
"Employee sID=" & [cboEmployee] & " and WorkLeave=5 and Finalized=False"

[UT227]

I get #ERROR

[xps35]

Is WorkLeave numeric and Finalized boolean (yes/no)?

[UT227]

Correct to both

[Welshgasman]

You did include the rest of the DSum and not just the code supplied, which was only meant to replace the criteria?

[UT227]

That was everything I did. I don't know of anything else to do.

[UT227]

Figured it out:
=Nz(DSum("LeaveHours","qrySchLeaveDates","Employee sID=" & [cboEmployee] & " and WorkLeaveID=5" & " and Finalized=False"))

[Welshgasman]

So all you needed in post #5 was workleaveid and not workleave ?
It is up to you to get the names correct all that was offered was the correct syntax.