I am having difficulties running this query. Can you see my problem?
INSERT INTO tblFootExam
(PatientID, DateTested, FootExamTypeID, FootExamResultID, ActiveProblem)
SELECT tblPatients.PatientID,
CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE,
2 AS ExamTypeID,
IIf(CDMS_MPF_PINDICATORS.INDICATOR_VALUE = 'Positive',
1,
IIf(CDMS_MPF_PINDICATORS.INDICATOR_VALUE = 'Negative', 2, 3)) AS ExamResultID,
CDMS_MPF_PINDICATORS.MPF_DATE_OF_SERVICE_KEY AS TempActive
FROM tblPatients INNER JOIN(CDMS_MPF_DATE_OF_SERVICE
INNER JOIN CDMS_MPF_PINDICATORS ON
CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE_KEY = CDMS_MPF_PINDICATORS.DATE_OF_SERVICE_KEY) ON tblPatients.PatientID = CDMS_MPF_PINDICATORS.MPF_PATIENT_KEY
WHERE (((CDMS_MPF_PINDICATORS ! INDICATOR_KEY) = 1455));
INSERT INTO tblFootExam
(PatientID, DateTested, FootExamTypeID, FootExamResultID, ActiveProblem)
SELECT tblPatients.PatientID,
CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE,
2 AS ExamTypeID,
IIf(CDMS_MPF_PINDICATORS.INDICATOR_VALUE = 'Positive',
1,
IIf(CDMS_MPF_PINDICATORS.INDICATOR_VALUE = 'Negative', 2, 3)) AS ExamResultID,
CDMS_MPF_PINDICATORS.MPF_DATE_OF_SERVICE_KEY AS TempActive
FROM tblPatients INNER JOIN(CDMS_MPF_DATE_OF_SERVICE
INNER JOIN CDMS_MPF_PINDICATORS ON
CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE_KEY = CDMS_MPF_PINDICATORS.DATE_OF_SERVICE_KEY) ON tblPatients.PatientID = CDMS_MPF_PINDICATORS.MPF_PATIENT_KEY
WHERE (((CDMS_MPF_PINDICATORS ! INDICATOR_KEY) = 1455));