SELECT consensusconference.WRAPNo, consensusconference.Visno, nCogAtVis, 

Switch(
   NZ(cc3,-999) = 1, "Dementia",
   NZ(cc2,-999)=1 Or (NZ(cc4_early,-999)=0 And NZ(cc4_clinical,-999)=0), "Cog_Unimpaired_Stable",                
   NZ(cc4e,-999) = 1, "Impaired_Not_MCI",
   NZ(cc4_early,-999) = -1, "Cog_Unimpared_Declining",
   NZ(cc4_clinical,-999) = -1, "Clinical_MCI") AS consensus_dx, 

Iif(NZ(cc3,-999) = 1, Switch(
                     NZ(cc5,-999) = 1, Switch(NZ(cc5a,-999) = 1, "Probable_AD_Primary", NZ(cc5a,-999) = 2, "Probable_AD_Secondary"),
                     NZ(cc6,-999) = 1, Switch(NZ(cc6a,-999) = 1, "Possible_AD_Primary", NZ(cc6a,-999) = 2, "Possible_AD_Secondary"))) AS dementia_type, 

Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4a,-999) = 1           or NZ(cc4b,-999) = 1, 1, 0),NULL) AS cons_memory, 

Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_lang,-999) = 1 or NZ(cc4c_lang,-999) = 1 or NZ(cc4d_lang,-999) = 1, 1, 0),NULL) AS cons_language, 

Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_att,-999) = 1    or NZ(cc4c_att,-999) = 1    or NZ(cc4d_att,-999) = 1, 1, 0),NULL) AS cons_attention, 

Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_exec,-999) = 1 or NZ(cc4c_exec,-999) = 1  or NZ(cc4d_exec,-999) = 1, 1, 0),NULL) AS cons_execfunc, 

Iif(NZ(cc3,-999) <> 1, Iif(NZ(cc4b_vis,-999) = 1    or NZ(cc4c_vis,-999) = 1     or NZ(cc4d_vis,-999) = 1, 1, 0),NULL) AS cons_visuospatial 

INTO ConsensusConferenceDiagnosis
FROM ConsensusConference LEFT JOIN qryTallies ON (ConsensusConference.wrapno = qryTallies.wrapno) AND (ConsensusConference.visno = qryTallies.visno)
ORDER BY consensusconference.WRAPNo, consensusconference.VisNo;