Thanks
SELECT LIPHMain.ID, LIPHMain.Connector, LIPHMain.FDate, LIPHMain.MIDate, LIPHMain.TransferDate, LIPHMain.PName, LIPHMain.TName, LIPHMain.ID, LIPHMain.FileNo, LIPHMain.UNumber, LIPHMain.CSS, LIPHMain.Manager, LIPHMain.AssDirector, LIPHMain.CAuditor, LIPHMain.PreviousGTotal, LIPHMain.FM1, LIPHMain.FM2, LIPHMain.FM3, LIPHMain.FM4, LIPHMain.FMS, LIPHMain.FMNote, LIPHMain.RE6, LIPHMain.RE7, LIPHMain.RE8, LIPHMain.RE9, LIPHMain.RE10, LIPHMain.RE11, LIPHMain.RE12, LIPHMain.RE13, LIPHMain.RE14, LIPHMain.RE15, LIPHMain.RE16, LIPHMain.RE17, LIPHMain.RE18, LIPHMain.RE19, LIPHMain.RE20, LIPHMain.RE21, LIPHMain.RE22, LIPHMain.RE23, LIPHMain.RE24, LIPHMain.RE25, LIPHMain.RE26, LIPHMain.RE27, LIPHMain.RE28, LIPHMain.RE29, LIPHMain.RE30, LIPHMain.RES, LIPHMain.RENote, LIPHMain.IN31, LIPHMain.IN32, LIPHMain.IN33, LIPHMain.IN34, LIPHMain.IN35, LIPHMain.IN36, LIPHMain.IN37, LIPHMain.IN38, LIPHMain.IN39, LIPHMain.IN40, LIPHMain.IN41, LIPHMain.IN42, LIPHMain.IN43, LIPHMain.IN44, LIPHMain.IN45, LIPHMain.IN46, LIPHMain.IN47, LIPHMain.IN48, LIPHMain.IN49, LIPHMain.IN50, LIPHMain.IN51, LIPHMain.IN52, LIPHMain.IN53, LIPHMain.INS, LIPHMain.INNote, LIPHMain.ML54, LIPHMain.ML55, LIPHMain.MLS, LIPHMain.MLNote, LIPHMain.LG56, LIPHMain.LG57, LIPHMain.LG58, LIPHMain.LG59, LIPHMain.LG60, LIPHMain.LG61, LIPHMain.LG62, LIPHMain.LG63, LIPHMain.LG64, LIPHMain.LG65, LIPHMain.LG66, LIPHMain.LG67, LIPHMain.LG68, LIPHMain.LG69, LIPHMain.LG70, LIPHMain.LG71, LIPHMain.LG72, LIPHMain.LG73, LIPHMain.LG74, LIPHMain.LG78, LIPHMain.LGS, LIPHMain.LGNote, LIPHMain.TF79, LIPHMain.TF80, LIPHMain.TF81, LIPHMain.TF82, LIPHMain.TF83, LIPHMain.TF84, LIPHMain.TF85, LIPHMain.TF86, LIPHMain.TF87, LIPHMain.TF88, LIPHMain.TF89, LIPHMain.TF90, LIPHMain.TFS, LIPHMain.TFNote, LIPHMain.CH91, LIPHMain.CH92, LIPHMain.CH92A, LIPHMain.CH92B, LIPHMain.CH99, LIPHMain.CHS, LIPHMain.CHNote, LIPHMain.LA100, LIPHMain.LA101, LIPHMain.LA102, LIPHMain.LA103, LIPHMain.LA104, LIPHMain.LA105, LIPHMain.LA106, LIPHMain.LA107, LIPHMain.LA108, LIPHMain.LA109, LIPHMain.LA110, LIPHMain.LA111, LIPHMain.LA112, LIPHMain.LA113, LIPHMain.LA114, LIPHMain.LA117, LIPHMain.LA118, LIPHMain.LA119, LIPHMain.LA120, LIPHMain.LA121, LIPHMain.LA122, LIPHMain.LA123, LIPHMain.LA124, LIPHMain.LA125, LIPHMain.LA126, LIPHMain.LA127, LIPHMain.LA128, LIPHMain.LA129, LIPHMain.LA130, LIPHMain.LA131, LIPHMain.LA132, LIPHMain.LA133, LIPHMain.LA134, LIPHMain.LA135, LIPHMain.LA136, LIPHMain.LA137, LIPHMain.LA138, LIPHMain.LAS, LIPHMain.LANote, LIPHMain.PI139, LIPHMain.PI140, LIPHMain.PI141, LIPHMain.PI142, LIPHMain.PI143, LIPHMain.PI144, LIPHMain.PI145, LIPHMain.PI146, LIPHMain.PI147, LIPHMain.PIS, LIPHMain.PINote, LIPHMain.OA148, LIPHMain.OA150, LIPHMain.OA151, LIPHMain.OA152, LIPHMain.OA153, LIPHMain.OA154, LIPHMain.OA155, LIPHMain.OA156, LIPHMain.OA157, LIPHMain.OA158, LIPHMain.OA159, LIPHMain.OA160, LIPHMain.OA161, LIPHMain.OA162, LIPHMain.OA163, LIPHMain.OA164, LIPHMain.OA165, LIPHMain.OA166, LIPHMain.OA167, LIPHMain.OA168, LIPHMain.OA169, LIPHMain.OA170, LIPHMain.OA171, LIPHMain.OA172, LIPHMain.OA173, LIPHMain.OA174, LIPHMain.OA175, LIPHMain.OA176, LIPHMain.OAS, LIPHMain.OANote, LIPHMain.CL177, LIPHMain.CL178, LIPHMain.CL179, LIPHMain.CL180, LIPHMain.CL181, LIPHMain.CL182, LIPHMain.CL183, LIPHMain.CL184, LIPHMain.CL185, LIPHMain.CL186, LIPHMain.CL187, LIPHMain.CL188, LIPHMain.CL189, LIPHMain.CL190, LIPHMain.CL191, LIPHMain.CL192, LIPHMain.CL193, LIPHMain.CL194, LIPHMain.CL195, LIPHMain.CL196, LIPHMain.CL197, LIPHMain.CL198, LIPHMain.CL199, LIPHMain.CL200, LIPHMain.CL201, LIPHMain.CL202, LIPHMain.CL203, LIPHMain.CL204, LIPHMain.CLS, LIPHMain.CLNote, LIPHMain.DueDate, LIPHMain.Notes, LIPHMain.[Final Note], IIF([LIPHMain]![FMS]=Yes,
([LIPHMain]![FM1]*[LIPHMainScore]![FM1])*-1+
([LIPHMain]![FM2]*[LIPHMainScore]![FM2])*-1+
([LIPHMain]![FM3]*[LIPHMainScore]![FM3])*-1+
([LIPHMain]![FM4]*[LIPHMainScore]![FM4])*-1,0) AS FMscore, IIF([LIPHMain]![RES]=Yes,
([LIPHMain]![RE6]*[LIPHMainScore]![RE6])*-1+
([LIPHMain]![RE7]*[LIPHMainScore]![RE7])*-1+
([LIPHMain]![RE8]*[LIPHMainScore]![RE8])*-1+
([LIPHMain]![RE9]*[LIPHMainScore]![RE9])*-1+
([LIPHMain]![RE10]*[LIPHMainScore]![RE10])*-1+
([LIPHMain]![RE11]*[LIPHMainScore]![RE11])*-1+
([LIPHMain]![RE12]*[LIPHMainScore]![RE12])*-1+
([LIPHMain]![RE13]*[LIPHMainScore]![RE13])*-1+
([LIPHMain]![RE14]*[LIPHMainScore]![RE14])*-1+
([LIPHMain]![RE15]*[LIPHMainScore]![RE15])*-1+
([LIPHMain]![RE16]*[LIPHMainScore]![RE16])*-1+
([LIPHMain]![RE17]*[LIPHMainScore]![RE17])*-1+
([LIPHMain]![RE18]*[LIPHMainScore]![RE18])*-1+
([LIPHMain]![RE19]*[LIPHMainScore]![RE19])*-1+
([LIPHMain]![RE20]*[LIPHMainScore]![RE20])*-1+
([LIPHMain]![RE21]*[LIPHMainScore]![RE21])*-1+
([LIPHMain]![RE22]*[LIPHMainScore]![RE22])*-1+
([LIPHMain]![RE23]*[LIPHMainScore]![RE23])*-1+
([LIPHMain]![RE24]*[LIPHMainScore]![RE24])*-1+
([LIPHMain]![RE25]*[LIPHMainScore]![RE25])*-1+
([LIPHMain]![RE26]*[LIPHMainScore]![RE26])*-1+
([LIPHMain]![RE27]*[LIPHMainScore]![RE27])*-1+
([LIPHMain]![RE28]*[LIPHMainScore]![RE28])*-1+
([LIPHMain]![RE29]*[LIPHMainScore]![RE29])*-1+
([LIPHMain]![RE30]*[LIPHMainScore]![RE30])*-1,0) AS REscore, IIF([LIPHMain]![INS]=Yes,
([LIPHMain]![IN31]*[LIPHMainScore]![IN31])*-1+
([LIPHMain]![IN32]*[LIPHMainScore]![IN32])*-1+
([LIPHMain]![IN33]*[LIPHMainScore]![IN33])*-1+
([LIPHMain]![IN34]*[LIPHMainScore]![IN34])*-1+
([LIPHMain]![IN35]*[LIPHMainScore]![IN35])*-1+
([LIPHMain]![IN36]*[LIPHMainScore]![IN36])*-1+
([LIPHMain]![IN37]*[LIPHMainScore]![IN37])*-1+
([LIPHMain]![IN38]*[LIPHMainScore]![IN38])*-1+
([LIPHMain]![IN39]*[LIPHMainScore]![IN39])*-1+
([LIPHMain]![IN40]*[LIPHMainScore]![IN40])*-1+
([LIPHMain]![IN41]*[LIPHMainScore]![IN41])*-1+
([LIPHMain]![IN42]*[LIPHMainScore]![IN42])*-1+
([LIPHMain]![IN43]*[LIPHMainScore]![IN43])*-1+
([LIPHMain]![IN44]*[LIPHMainScore]![IN44])*-1+
([LIPHMain]![IN45]*[LIPHMainScore]![IN45])*-1+
([LIPHMain]![IN46]*[LIPHMainScore]![IN46])*-1+
([LIPHMain]![IN47]*[LIPHMainScore]![IN47])*-1+
([LIPHMain]![IN48]*[LIPHMainScore]![IN48])*-1+
([LIPHMain]![IN49]*[LIPHMainScore]![IN49])*-1+
([LIPHMain]![IN50]*[LIPHMainScore]![IN50])*-1+
([LIPHMain]![IN51]*[LIPHMainScore]![IN51])*-1+
([LIPHMain]![IN52]*[LIPHMainScore]![IN52])*-1+
([LIPHMain]![IN53]*[LIPHMainScore]![IN53])*-1,0) AS INscore, IIF([LIPHMain]![MLS]=Yes,
([LIPHMain]![ML54]*[LIPHMainScore]![ML54])*-1+
([LIPHMain]![ML55]*[LIPHMainScore]![ML55])*-1,0) AS MLscore, IIF([LIPHMain]![LGS]=Yes,
([LIPHMain]![LG56]*[LIPHMainScore]![LG56])*-1+
([LIPHMain]![LG57]*[LIPHMainScore]![LG57])*-1+
([LIPHMain]![LG58]*[LIPHMainScore]![LG58])*-1+
([LIPHMain]![LG59]*[LIPHMainScore]![LG59])*-1+
([LIPHMain]![LG60]*[LIPHMainScore]![LG60])*-1+
([LIPHMain]![LG61]*[LIPHMainScore]![LG61])*-1+
([LIPHMain]![LG62]*[LIPHMainScore]![LG62])*-1+
([LIPHMain]![LG63]*[LIPHMainScore]![LG63])*-1+
([LIPHMain]![LG64]*[LIPHMainScore]![LG64])*-1+
([LIPHMain]![LG65]*[LIPHMainScore]![LG65])*-1+
([LIPHMain]![LG66]*[LIPHMainScore]![LG66])*-1+
([LIPHMain]![LG67]*[LIPHMainScore]![LG67])*-1+
([LIPHMain]![LG68]*[LIPHMainScore]![LG68])*-1+
([LIPHMain]![LG69]*[LIPHMainScore]![LG69])*-1+
([LIPHMain]![LG70]*[LIPHMainScore]![LG70])*-1+
([LIPHMain]![LG71]*[LIPHMainScore]![LG71])*-1+
([LIPHMain]![LG72]*[LIPHMainScore]![LG72])*-1+
([LIPHMain]![LG73]*[LIPHMainScore]![LG73])*-1+
([LIPHMain]![LG74]*[LIPHMainScore]![LG74])*-1+
([LIPHMain]![LG78]*[LIPHMainScore]![LG78])*-1,0) AS LGscore, IIF([LIPHMain]![TFS]=Yes,
([LIPHMain]![TF79]*[LIPHMainScore]![TF79])*-1+
([LIPHMain]![TF80]*[LIPHMainScore]![TF80])*-1+
([LIPHMain]![TF81]*[LIPHMainScore]![TF81])*-1+
([LIPHMain]![TF82]*[LIPHMainScore]![TF82])*-1+
([LIPHMain]![TF83]*[LIPHMainScore]![TF83])*-1+
([LIPHMain]![TF84]*[LIPHMainScore]![TF84])*-1+
([LIPHMain]![TF85]*[LIPHMainScore]![TF85])*-1+
([LIPHMain]![TF86]*[LIPHMainScore]![TF86])*-1+
([LIPHMain]![TF87]*[LIPHMainScore]![TF87])*-1+
([LIPHMain]![TF88]*[LIPHMainScore]![TF88])*-1+
([LIPHMain]![TF89]*[LIPHMainScore]![TF89])*-1+
([LIPHMain]![TF90]*[LIPHMainScore]![TF90])*-1,0) AS TFscore, IIF([LIPHMain]![CHS]=Yes,
([LIPHMain]![CH91]*[LIPHMainScore]![CH91])*-1+
([LIPHMain]![CH92]*[LIPHMainScore]![CH92])*-1+
([LIPHMain]![CH92A]*[LIPHMainScore]![CH92A])*-1+
([LIPHMain]![CH92B]*[LIPHMainScore]![CH92B])*-1+
([LIPHMain]![CH99]*[LIPHMainScore]![CH99])*-1,0) AS CHScore, IIF([LIPHMain]![LAS]=Yes,
([LIPHMain]![LA100]*[LIPHMainScore]![LA100])*-1+
([LIPHMain]![LA101]*[LIPHMainScore]![LA101])*-1+
([LIPHMain]![LA102]*[LIPHMainScore]![LA102])*-1+
([LIPHMain]![LA103]*[LIPHMainScore]![LA103])*-1+
([LIPHMain]![LA104]*[LIPHMainScore]![LA104])*-1+
([LIPHMain]![LA105]*[LIPHMainScore]![LA105])*-1+
([LIPHMain]![LA106]*[LIPHMainScore]![LA106])*-1+
([LIPHMain]![LA107]*[LIPHMainScore]![LA107])*-1+
([LIPHMain]![LA108]*[LIPHMainScore]![LA108])*-1+
([LIPHMain]![LA109]*[LIPHMainScore]![LA109])*-1+
([LIPHMain]![LA110]*[LIPHMainScore]![LA110])*-1+
([LIPHMain]![LA111]*[LIPHMainScore]![LA111])*-1+
([LIPHMain]![LA112]*[LIPHMainScore]![LA112])*-1+
([LIPHMain]![LA113]*[LIPHMainScore]![LA113])*-1+
([LIPHMain]![LA114]*[LIPHMainScore]![LA114])*-1+
([LIPHMain]![LA117]*[LIPHMainScore]![LA117])*-1+
([LIPHMain]![LA118]*[LIPHMainScore]![LA118])*-1+
([LIPHMain]![LA119]*[LIPHMainScore]![LA119])*-1+
([LIPHMain]![LA120]*[LIPHMainScore]![LA120])*-1+
([LIPHMain]![LA121]*[LIPHMainScore]![LA121])*-1+
([LIPHMain]![LA122]*[LIPHMainScore]![LA122])*-1+
([LIPHMain]![LA123]*[LIPHMainScore]![LA123])*-1+
([LIPHMain]![LA124]*[LIPHMainScore]![LA124])*-1+
([LIPHMain]![LA125]*[LIPHMainScore]![LA125])*-1+
([LIPHMain]![LA126]*[LIPHMainScore]![LA126])*-1+
([LIPHMain]![LA127]*[LIPHMainScore]![LA127])*-1+
([LIPHMain]![LA128]*[LIPHMainScore]![LA128])*-1+
([LIPHMain]![LA129]*[LIPHMainScore]![LA129])*-1+
([LIPHMain]![LA130]*[LIPHMainScore]![LA130])*-1+
([LIPHMain]![LA131]*[LIPHMainScore]![LA131])*-1+
([LIPHMain]![LA132]*[LIPHMainScore]![LA132])*-1+
([LIPHMain]![LA133]*[LIPHMainScore]![LA133])*-1+
([LIPHMain]![LA134]*[LIPHMainScore]![LA134])*-1+
([LIPHMain]![LA135]*[LIPHMainScore]![LA135])*-1+
([LIPHMain]![LA136]*[LIPHMainScore]![LA136])*-1+
([LIPHMain]![LA137]*[LIPHMainScore]![LA137])*-1+
([LIPHMain]![LA138]*[LIPHMainScore]![LA138])*-1,0) AS LAScore, IIF([LIPHMain]![PIS]=Yes,
([LIPHMain]![PI139]*[LIPHMainScore]![PI139])*-1+
([LIPHMain]![PI140]*[LIPHMainScore]![PI140])*-1+
([LIPHMain]![PI141]*[LIPHMainScore]![PI141])*-1+
([LIPHMain]![PI142]*[LIPHMainScore]![PI142])*-1+
([LIPHMain]![PI143]*[LIPHMainScore]![PI143])*-1+
([LIPHMain]![PI144]*[LIPHMainScore]![PI144])*-1+
([LIPHMain]![PI145]*[LIPHMainScore]![PI145])*-1+
([LIPHMain]![PI146]*[LIPHMainScore]![PI146])*-1+
([LIPHMain]![PI147]*[LIPHMainScore]![PI147])*-1,0) AS PIScore, IIF([LIPHMain]![OAS]=Yes,
([LIPHMain]![OA148]*[LIPHMainScore]![OA148])*-1+
([LIPHMain]![OA150]*[LIPHMainScore]![OA150])*-1+
([LIPHMain]![OA151]*[LIPHMainScore]![OA151])*-1+
([LIPHMain]![OA152]*[LIPHMainScore]![OA152])*-1+
([LIPHMain]![OA153]*[LIPHMainScore]![OA153])*-1+
([LIPHMain]![OA154]*[LIPHMainScore]![OA154])*-1+
([LIPHMain]![OA155]*[LIPHMainScore]![OA155])*-1+
([LIPHMain]![OA156]*[LIPHMainScore]![OA156])*-1+
([LIPHMain]![OA157]*[LIPHMainScore]![OA157])*-1+
([LIPHMain]![OA158]*[LIPHMainScore]![OA158])*-1+
([LIPHMain]![OA159]*[LIPHMainScore]![OA159])*-1+
([LIPHMain]![OA160]*[LIPHMainScore]![OA160])*-1+
([LIPHMain]![OA161]*[LIPHMainScore]![OA161])*-1+
([LIPHMain]![OA162]*[LIPHMainScore]![OA162])*-1+
([LIPHMain]![OA163]*[LIPHMainScore]![OA163])*-1+
([LIPHMain]![OA164]*[LIPHMainScore]![OA164])*-1+
([LIPHMain]![OA165]*[LIPHMainScore]![OA165])*-1+
([LIPHMain]![OA166]*[LIPHMainScore]![OA166])*-1+
([LIPHMain]![OA167]*[LIPHMainScore]![OA167])*-1+
([LIPHMain]![OA168]*[LIPHMainScore]![OA168])*-1+
([LIPHMain]![OA169]*[LIPHMainScore]![OA169])*-1+
([LIPHMain]![OA170]*[LIPHMainScore]![OA170])*-1+
([LIPHMain]![OA171]*[LIPHMainScore]![OA171])*-1+
([LIPHMain]![OA172]*[LIPHMainScore]![OA172])*-1+
([LIPHMain]![OA173]*[LIPHMainScore]![OA173])*-1+
([LIPHMain]![OA174]*[LIPHMainScore]![OA174])*-1+
([LIPHMain]![OA175]*[LIPHMainScore]![OA175])*-1+
([LIPHMain]![OA176]*[LIPHMainScore]![OA176])*-1,0) AS OAScore, IIF([LIPHMain]![CLS]=Yes,
([LIPHMain]![CL177]*[LIPHMainScore]![CL177])*-1+
([LIPHMain]![CL178]*[LIPHMainScore]![CL178])*-1+
([LIPHMain]![CL179]*[LIPHMainScore]![CL179])*-1+
([LIPHMain]![CL180]*[LIPHMainScore]![CL180])*-1+
([LIPHMain]![CL181]*[LIPHMainScore]![CL181])*-1+
([LIPHMain]![CL182]*[LIPHMainScore]![CL182])*-1+
([LIPHMain]![CL183]*[LIPHMainScore]![CL183])*-1+
([LIPHMain]![CL184]*[LIPHMainScore]![CL184])*-1+
([LIPHMain]![CL185]*[LIPHMainScore]![CL185])*-1+
([LIPHMain]![CL186]*[LIPHMainScore]![CL186])*-1+
([LIPHMain]![CL187]*[LIPHMainScore]![CL187])*-1+
([LIPHMain]![CL188]*[LIPHMainScore]![CL188])*-1+
([LIPHMain]![CL189]*[LIPHMainScore]![CL189])*-1+
([LIPHMain]![CL190]*[LIPHMainScore]![CL190])*-1+
([LIPHMain]![CL191]*[LIPHMainScore]![CL191])*-1+
([LIPHMain]![CL192]*[LIPHMainScore]![CL192])*-1+
([LIPHMain]![CL193]*[LIPHMainScore]![CL193])*-1+
([LIPHMain]![CL194]*[LIPHMainScore]![CL194])*-1+
([LIPHMain]![CL195]*[LIPHMainScore]![CL195])*-1+
([LIPHMain]![CL196]*[LIPHMainScore]![CL196])*-1+
([LIPHMain]![CL197]*[LIPHMainScore]![CL197])*-1+
([LIPHMain]![CL198]*[LIPHMainScore]![CL198])*-1+
([LIPHMain]![CL199]*[LIPHMainScore]![CL199])*-1+
([LIPHMain]![CL200]*[LIPHMainScore]![CL200])*-1+
([LIPHMain]![CL201]*[LIPHMainScore]![CL201])*-1+
([LIPHMain]![CL202]*[LIPHMainScore]![CL202])*-1+
([LIPHMain]![CL203]*[LIPHMainScore]![CL203])*-1+
([LIPHMain]![CL204]*[LIPHMainScore]![CL204])*-1,0) AS CLScore
FROM LIPHMainScore INNER JOIN LIPHMain ON LIPHMainScore.Connector = LIPHMain.Connector;