SELECT fqry.WRAPNo, fqry.VisNo, 

-1*(NonMiss(mmsetot)+NonMiss(trla)+NonMiss(trlb)+NonMiss(ttotal)+NonMiss(drraw)+NonMiss(bvmttot)+NonMiss(bvmtdel)+NonMiss(wmsrtot)+NonMiss(wmsrtot2)
+NonMiss(stroocw)+NonMiss(waisrtot)+NonMiss(animtotraw)+NonMiss(cdtts)) AS nCogAtVis, 

-1*(NonMiss(folica1)+NonMiss(homocy1)+NonMiss(creat1)+NonMiss(choles1)+NonMiss(triglycerides)+NonMiss(LDL_calc)+NonMiss(insulin)+NonMiss(HDL)+NonMiss(IL6)
+NonMiss(CReProt)+NonMissLong(B12)+NonMiss(glucose)+NonMiss(TotVitamin)) AS nLabAtVis, 

-1*(NonMiss(PFMBID)+NonMiss(GHDAID)+NonMiss(MHID)) AS nFormAtVis, 

-1*(NonMiss(height)+NonMiss(weight)+NonMiss(waist)+NonMiss(hip)+NonMiss(s_bp)+NonMiss(d_bp)+NonMiss(pulse)) AS nVitAtVis, 

IIf(NonMiss(CDRRating) Or (NonMiss(QD_TotalScore) And QD_TotalScore<1000),1,IIf(CDRRating=777 Or QD_TotalScore=777,777,0)) AS IfmtClin, 

IIf(IADL.Total=777 Or IQCode.Total=777,777,-1*(NonMiss(IADL.Total)+NonMiss(IQCode.Total))) AS IfmtScale, 

-1*NonMiss(CogStateID) AS CogState

FROM (((((((((((SELECT E.wrapno, TS.visno FROM testingschedule AS ts LEFT JOIN fqryStatisticalData AS e ON ts.dbid = e.dbid 

WHERE ( (wrapno is not null) AND (E.VisNo = 1) ) )  AS fqry 

LEFT JOIN neuropsychscores AS np ON (fqry.wrapno = np.wrapno) AND (fqry.visno = np.visno)) 
LEFT JOIN Med_Lab ON (fqry.visno = Med_Lab.visno) AND (fqry.wrapno = Med_Lab.wrapno)) 
LEFT JOIN MedHistory ON (fqry.visno = MedHistory.visno) AND (fqry.wrapno = MedHistory.wrapno)) 
LEFT JOIN GenHealthDailyAct AS ghda ON (fqry.visno = ghda.visno) AND (fqry.wrapno = ghda.wrapno)) 
LEFT JOIN PersFamMedBack AS pfmb ON (fqry.visno = pfmb.visno) AND (fqry.wrapno = pfmb.wrapno)) 
LEFT JOIN VisitVitals AS vv ON (fqry.visno = vv.visno) AND (fqry.wrapno = vv.wrapno)) 
LEFT JOIN CDR ON (fqry.wrapno = CDR.wrapno) AND (fqry.visno = CDR.visno)) 
LEFT JOIN QuickDementia AS qd ON (fqry.wrapno = qd.wrapno) AND (fqry.visno = qd.visno)) 
LEFT JOIN IADL ON (fqry.wrapno = IADL.wrapno) AND (fqry.visno = IADL.visno)) 
LEFT JOIN IQCode ON (fqry.wrapno = IQCode.wrapno) AND (fqry.visno = IQCode.visno)) 
LEFT JOIN CogStateData AS csd ON (fqry.visno = csd.visno) AND (fqry.wrapno = csd.wrapno)

ORDER BY fqry.WRAPNo, fqry.VisNo;