I have a form that captures yes/no responses. The forms control source is a table called tblEpisode
I have a query called qryEpisode, here is part of it:
SELECT tblPatient.Patient_Name, IIf([PastMedical_StrokeTIA]="Yes",2,0) AS StrokeTIAChadsVasc, IIf([Hypertension]="Yes",1,0) AS HypertensionChadsVasc, [StrokeTIAChadsVasc]+[HypertensionChadsVasc] AS SCORE
FROM tblPatient LEFT JOIN tblEpisode ON tblPatient.PatientID = tblEpisode.PatientID;
This bit helps me calculate a score based on the responses.
If i try to have qryEpisode as the control source of the form and add the field SCORE to then form it will not let me update the record.
How can I overcome this
I have a query called qryEpisode, here is part of it:
SELECT tblPatient.Patient_Name, IIf([PastMedical_StrokeTIA]="Yes",2,0) AS StrokeTIAChadsVasc, IIf([Hypertension]="Yes",1,0) AS HypertensionChadsVasc, [StrokeTIAChadsVasc]+[HypertensionChadsVasc] AS SCORE
FROM tblPatient LEFT JOIN tblEpisode ON tblPatient.PatientID = tblEpisode.PatientID;
This bit helps me calculate a score based on the responses.
If i try to have qryEpisode as the control source of the form and add the field SCORE to then form it will not let me update the record.
How can I overcome this