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?