Query Criteria IIF Statement Multiple True parts

mardi 24 février 2015

Forgive me if this has been covered but have been searching and haven't come up with what I'm looking for.



I'm trying to have a single or multiple query criteria based on what the user checks on a form.



I can't get the True condition to work at all, I get no records. Here is what I'm using



IIf([Forms]![FrmAttendanceLogsRpt]![BlkFilter]=-1,[TempVars]![EID] Or 86,[TempVars]![EID])



If I just put

[TempVars]![EID] Or 86

in the Criteria it works just fine.

Query Criteria IIF Statement Multiple True parts

0 commentaires:

Enregistrer un commentaire

Labels