Home > IT Answers > Microsoft Windows > Using WildCards in IIF Statement
RoadDust
390 pts.
 Using WildCards in IIF Statement
Access query, IIF statement, Microsoft Access, SQL, Wildcards
Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria: IIf([Forms]![ContractPOSchedule]![PONoVar] Is Not Null,[Forms]![ContractPOSchedule]![PONoVar],([tblContractPOs].[ContractPO]) Like "*") If I enter something in the field on the form then it only displays those records but if the field is blank then nothing gets displayed. Do I have my syntax wrong in the IIF statement? Any help would be greatly appreciated. Dustin

Software/Hardware used:
ASKED: December 17, 2008  3:38 PM
UPDATED: December 17, 2008  9:27 PM
RELATED QUESTIONS
Answer Wiki:
Instead of Is Not Null, try <>0
Last Wiki Answer Submitted:  December 17, 2008  9:27 pm  by  Celogan   35 pts.
All Answer Wiki Contributors:  Celogan   35 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _