Interview Question in Microsoft Transact-SQL
Interview Question :: Access if / then (IIF) assistance
I am trying to return a result set based off some passed parameters and a conditional statement. I have been programming in T-SQL for awhile, but not at all in Access and it seems the syntax is different. The code I currently am looking at is below:
parameters auditDate DateTime, [match] Text ( 255 );
IIf (FacilityAudit.[MonthYear] like [auditDate],
(SELECT FacilityAuditQuestions.AuditSection, FacilityAuditQuestions.Points, FacilityAudit.Points AS TotalPoints, FacilityAuditQuestions.Question, FacilityAudit.Auditor, FacilityAudit.OptYes, FacilityAudit.OptNo, FacilityAudit.Notes, FacilityAudit.MonthYear FROM FacilityAudit RIGHT JOIN FacilityAuditQuestions ON FacilityAudit.AuditSection=FacilityAudit...
select FacilityAuditQuestions.Questions from FacilityAuditQuestions where [Match] like FacilityAuditQuestions.AuditSection)
ORDER BY FacilityAuditQuestions.AuditSection;
What I am trying to do is if the Dates match, return certain questions based off of AuditSection codes. If it does not match then return all questions. Any help in the Access coding would be appreciated.
Loading ...