SELECT funeralcase.caseno, ; funeralcase.traffic, ; funeralcase.entity, ; funeralcase.casedate, ; funeralcase.casetype, ; funeralcase.decpin, ; funeralcase.fdcode, ; funeralcase.disptype, ; funeralcase.dispother, ; funeralcase.agebracket, ; funeralcase.agemonths, ; funeralcase.agedays, ; funeralcase.agehours, ; funeralcase.ageminutes, ; funeralcase.calldate, ; funeralcase.calltime, ; funeralcase.takenby, ; funeralcase.calltype, ; funeralcase.callerpin, ; funeralcase.famnotified, ; funeralcase.hospcode, ; funeralcase.famowns, ; funeralcase.famcemetery, ; funeralcase.famburied, ; funeralcase.famwhom, ; funeralcase.persbelong, ; funeralcase.fcnotes, ; 0 AS nisnew, ; Purchasr.fullname AS decnamesort, ; Purchasr.dob, ; Purchasr.dod, ; Purchasr.age, ; Purchasr.deceased, ; Purchasr.ssn, ; ICASE(funeralcase.casetype="A", "AtNeed ", funeralcase.casetype="P", "PreNeed", SPACE(7)) AS casetypedesc, ; IIF( funeralcase.podtype = 'DH', purchasr.state1, IIF(funeralcase.podtype = 'OT', funeralcase.podstate, ivendor.bstate)) AS deathstate, ; funeralcase.shiptype; FROM Funeral!funeralcase ; LEFT JOIN nexus!purchasr ; ON funeralcase.decpin == Purchasr.pin ; LEFT JOIN ivendor ; ON funeralcase.podvendor == ivendor.vendor ; WHERE funeralcase.caseno LIKE ( ?PKValue ) ; AND funeralcase.caseno LIKE ( ?FindCaseNo ) ; ORDER BY funeralcase.casenoAnd this is the definition for the one that is giving me the problems:
SELECT funeralcase.caseno, ; funeralcase.traffic, ; .f. AS Review; FROM funeral!funeralcase ; WHERE funeralcase.caseno LIKE ( ?PKValue ) ; ORDER BY funeralcase.caseno