Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query not working

Status
Not open for further replies.

acorbally

Programmer
Jan 9, 2001
65
US
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));
 
I am having difficulties running this query
Any error message ? Unexpected behaviour ?
Have you tried to run the select alone ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Actually there is a mistake in my query above. It should be:

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));

The ! should have been a . The problem I run into is when I run the query it is asking to enter a parameter for CDMS_MPF_DATE_OF_SERVICE.DATE_OF_SERVICE_KEY. I don't understand why?
 
Has the CDMS_MPF_DATE_OF_SERVICE table a column named DATE_OF_SERVICE_KEY ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top