AboutManish Batola Expertise ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions and many more being added every year.
Experience 24 yrs in the Software industry with 18yrs completely dedicated on more than 200 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.
Organizations Worked in various multinationals catering from Aerospace, Oil & Gas etc.
Expert: Manish Batola Date: 7/25/2008 Subject: Multiple If statements
Question I'm having trouble writing a multiple IIf statement in a query. Here are the conditions that I'm attempting capture.
IIF([Date of Visit]<[Hire_DATE] or [PROMODATE] or [TRANSDATE],[Date of Visit]+90), IIF([Date of Visit]>[Hire_DATE],[Hire_Date]+90), IIF(Date of Visit]>[PROMODATE],[PROMODATE]+90), IIF[Date of Visit]>[TRANSDATE],[TRANSDATE]+90))
Answer Hi Terry,
If your gonna have an "OR" statement in your IIF() statements, then I would advice you to split this into a multi-liner if then else statement on the AfterUpdate event of your form field and then have the result on your query.
The iif() format example is as below
=IIf([Confirmed] = "Yes", "Order Confirmed", "Order Not Confirmed")
As per your statements I'm confused cause I cannot see where your condition fails. Try to get rid of the OR statements.
