Software

SELECT AB3632IEPDueDate, AB3632IEPStart, AB3632IEPStop, Address1, Address2, Address3, AlternativeAddress2, AlternativeCity,AlternativeInfo, AlternativeOthPhone, AlternativePhone, AlternativeState, AlternativeZip, AssessmentReportDueDate, AssessorType, Exp_Date AS AuthorizationEnd, [Authorizations].[Start_Date] AS AuthorizationStart,BIRTHDATE,BIS, CensusTract, City, Client_Event_Date, ClientStatusCode, ConsentReceived, CREAT_DATE, DayTreatmentReferral,DHS_Client, EducationLevel, FIRST_NAME,FMP_Client, Home_Phone, Prov_Name AS InitialAssessmentAuthorization, IIf(IsNull([Insurance_Num])," - ",[Insurance_Num]) AS InsuranceNumber, LAST_NAME, Letter1Sent,Letter2Sent,LivingSituation, MIDDLE, NewSchool, NOTE, Oth_Phone, OtherCountyDepartment,OutOfCountySFDept, ParentLanguage, Probation, ProgReferralSent,Race, Race_Descript,Re_Referral,ReferralConfirmation,ReferralDate, RefSchool,ReferralSentTo, ResidentialRequest, PHYS_ADDR1 AS SchoolAddr1, [dbo_PROVSITE].[PHYS_ADDR2] AS SchoolAddr2, [dbo_PROVSITE].[PHYS_ADDR3] AS SchoolAddr3, [dbo_PROVSITE].[PHYS_CITY] AS SchoolCity, SchoolFax, [dbo_PROVIDER].[NAME] AS SchoolName, [dbo_PROVSITE].[PHYS_PHONE] AS SchoolPhone, [dbo_PROVSITE].[PHYS_STATE] AS SchoolState, [dbo_PROVSITE].[PHYS_ZIP] AS SchoolZip, SEX, SFUSD_ID, SFUSDMemoSent, SpecialEdCode, SpecialEdTeacher, SS_NUMBER, State, Teacher2, Teacher2Phone, TeacherPhone, TransferFromOtherCounty, Work_Phone, Zip_Code

EventArray is the name of a table. RefSchool and EXT_ID are fields in tables - you would know which tables except that the comment field was not big enough to take them. I have used the IIF construct successfully outside reports. When I copy the SQLtext into a new query the new query works for a while but then starts saying "Invalid operation".