1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT QUESTIONS.type_question,
IIf([type_question]='PROFIL',
SELECT PROFILS.no_etude, QUESTIONS.no_etude, QUESTIONS.modalite_min, QUESTIONS.modalite_max, PROFILS.note,
IIf([modalite_min]=1 And [modalite_max]=9,(([PROFILS.note]-5)*1.25)+5,
IIf([modalite_min]=1 And [modalite_max]=7,(([PROFILS.note]-4)*1.67)+5,
IIf([modalite_min]=1 And [modalite_max]=5,(([PROFILS.note]-3)*2.5)+5)))
AS NOTE_POND
FROM PROFILS INNER JOIN QUESTIONS ON PROFILS.no_etude = QUESTIONS.no_etude;
IIf([type_question]='CHOIX ATT',
SELECT CHOIXATT.no_etude, QUESTIONS.no_etude, QUESTIONS.modalite_min, QUESTIONS.modalite_max, CHOIXATT.reponse,
IIf([modalite_min]=1 And [modalite_max]=9,(([CHOIXATT.reponse]-5)*1.25)+5,
IIf([modalite_min]=1 And [modalite_max]=7,(([CHOIXATT.reponse]-4)*1.67)+5,
IIf([modalite_min]=1 And [modalite_max]=5,(([CHOIXATT.reponse]-3)*2.5)+5)))
AS NOTE_POND
FROM PROFILS INNER JOIN QUESTIONS ON PROFILS.no_etude = QUESTIONS.no_etude;
IIf([type_question]='CARAC ATT',
SELECT CARACATT.no_etude, QUESTIONS.no_etude, QUESTIONS.modalite_min, QUESTIONS.modalite_max, CARACATT.reponse,
IIf([modalite_min]=1 And [modalite_max]=9,(([CARACATT.reponse]-5)*1.25)+5,
IIf([modalite_min]=1 And [modalite_max]=7,(([CARACATT.reponse]-4)*1.67)+5,
IIf([modalite_min]=1 And [modalite_max]=5,(([CARACATT.reponse]-3)*2.5)+5)))
AS NOTE_POND
FROM PROFILS INNER JOIN QUESTIONS ON PROFILS.no_etude = QUESTIONS.no_etude;
FROM QUESTIONS; |
Partager