Query expression that shows either zero or one

Question

I am getting an error in my querys expression saying syntax error coma in query expression. what is wrong with it?

[FIXED] thanks Gustav

IIf(DCount("DateCompleted","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID])=DCount("*","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID] & ""),1,0)

No IIF says the expression you entered has a function containing the wrong number of arguments. — SoggyCashew, Sep 01 '18 at 17:22

score 0 · Accepted Answer · answered Sep 01 '18 at 20:47

0

It should read:

IIf(DCount("*","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID] & "")=DCount("*","tblFunctionRequirements","FuncID =" & [FuncID] & ""),1,0)

Or:

Abs(DCount("*","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID] & "")=DCount("*","tblFunctionRequirements","FuncID =" & [FuncID] & ""))

answered Sep 01 '18 at 20:47

Gustav

53,498
7
29
55

Both give a answer of 1 all the time even its supposed to be zero. – SoggyCashew Sep 01 '18 at 22:50
ok, I split them and checked to see why and the two halfs are giving the same results thats the reason – SoggyCashew Sep 01 '18 at 23:06
IIf(DCount("DateCompleted","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID])=DCount("*","tblEmployeeRequirements","EmpFuncID=" & [EmpFuncID] & ""),1,0) – SoggyCashew Sep 01 '18 at 23:12
Those two parts will always return identical results as well. – Gustav Sep 02 '18 at 06:32

masasa · Answer 2 · 2018-09-01T16:21:28.733

-1

you should use IFF

checkout this answer:

edited Sep 01 '18 at 16:21

answered Sep 01 '18 at 15:47

masasa

260
1
9

didnt notice , he can use this then https://stackoverflow.com/questions/772461/case-expressions-in-access – masasa Sep 01 '18 at 16:20

Query expression that shows either zero or one

2 Answers2