1. 8_9GF_Qty

SELECT MTP_master.NIIN AS Expr1, Sum(dbo_requisition.quantity) AS SumOfquantity, dbo_requisition.project_code, MTP_master.Shop AS Expr2

FROM MTP_master, dbo_requisition

GROUP BY MTP_master.NIIN, dbo_requisition.project_code, MTP_master.Shop

HAVING (((dbo_requisition.project_code) Like [Enter Project code] & "*") AND ((MTP_master.Shop) Like [forms]![switchboard]![shop select] & "*"))

ORDER BY Sum(dbo_requisition.quantity) DESC;

2. chart

SELECT [5_data].Master_NSN AS nsn, [5_data].Shop AS PSSD, [Preferred Nouns].NOUN AS Noun, [5_data].[CNTL-NR] AS PDN, [5_data].F_days AS [Flow Days], [5_data].WL, [5_data].CSI_OH AS [09 Assets], [5_data].CRI, [5_data].G019C AS Expr3, [5_data].rqd AS NRO, [5_data].BO_Tot AS [Total Backorders], [5_data].MICAP AS MICAPs, [5_data].OWO, Null AS Color, Null AS overall, [5_data].YBQ AS Expr4, [5_data].Prod, [5_data].QDR, [5_data].FSC, [5_data].MMAC, [5_data].NIIN, [Preferred Nouns].Engine AS TMS, problems_table.Forecast, problems_table.Act_FD, problems_table.AWP_F, problems_table.[Parts Problem], problems_table.Other, problems_table.Cont_Prod, problems_table.[Equip 1], problems_table.[Equip 2], problems_table.[Equip 3], problems_table.[Equip 4], problems_table.[Equip 5], problems_table.[Equip 6], problems_table.P_N, problems_table.Contract_OWO, [5_data].SOS, [5_data].ORG, problems_table.Personnel, [5_data].POS_A, [5_data].Item_Count, [5_data].Carc_Avail, [5_data].Parts_avail, [5_data].Hours_Avail, [5_data].Funds_Avail, [5_data].Sort_Value, [5_data].Pushed AS Expr19, [5_data].RSP_A, [5_data].CSI_OH AS Expr21, [5_data].[BOA+YBQ] AS Expr22, problems_table.Cont_forecast, problems_table.contract_cri, problems_table.[I&S], [5_data].Target, problems_table.Awp_G, problems_table.[AWP Days], [5_data].NAME, [5_data].PHONE, [5_data].FirstQuarterPastRepair, [5_data].SecondQuarterPastRepair, [5_data].ThirdQuarterPastRepair, [5_data].FirstQuarterPastAddlRepair, [5_data].SecondQuarterPastAddlRepair, [5_data].ThirdQuarterPastAddlRepair, [5_data].RO, [5_data].[Base Assets], [5_data].[Due Out], [Preferred Nouns].FINAL, [5_data].[Field MICAP], [5_data].[Cond-Y] AS Expr36, [5_data].[Cond-Z] AS Expr37, [Monthly Production Archive].[end month1 prod], [Monthly Production Archive].[End month2 prod]

FROM ((5_data INNER JOIN problems_table ON [5_data].NIIN = problems_table.niin) LEFT JOIN [Monthly Production Archive] ON [5_data].NIIN = [Monthly Production Archive].NIIN) LEFT JOIN [Preferred Nouns] ON [5_data].NIIN = [Preferred Nouns].niin

WHERE ((([5_data].Shop) Like [forms]![switchboard]![shop select].[value] & "*"));

3. Daily MICAP and BO Report

SELECT MTP_master.Shop AS Expr1, MTP_master.[CNTL-NR] AS [Cntrl#], MTP_master.FSC AS Expr2, MTP_master.NIIN AS Expr3, MTP_master.MMAC AS MC, dbo_MasterQueryTable.Noun, MTP_master.ORG AS Expr4, MTP_master.MICAP AS Expr5, MTP_master.[BACKORDERS-JCS] AS JCS, MTP_master.YBQ AS Expr6, MTP_master.HP_Total AS 700s, MTP_master.BO_Tot AS [Total BOs], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-A] AS [A Cond], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Z] AS [Z Cond], MTP_master.OWO AS Expr7, MTP_master.Prod AS Expr8, dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F Cond], MTP_master.Carc_Avail AS Carc, MTP_master.Parts_avail AS Parts, MTP_master.Hours_Avail AS Hours, MTP_master.Funds_Avail AS Funds

FROM dbo_MasterQueryTable, MTP_master

WHERE (((MTP_master.Shop) Like forms!switchboard![shop select].value & "*"))

ORDER BY MTP_master.Shop, MTP_master.[CNTL-NR];

4. I&S

SELECT dbo_Actl2MstrNIIN.Actl_NIIN, dbo_Actl2MstrNIIN.Mstr_NIIN

FROM MTP_master LEFT JOIN dbo_Actl2MstrNIIN ON MTP_master.NIIN = dbo_Actl2MstrNIIN.InS_NIIN

WHERE (((dbo_Actl2MstrNIIN.Mstr_NIIN)=[forms]![problems_table].[niin]));

5. Select Problem_items by PSSD

SELECT problems_table.*, MTP_master.Shop

FROM problems_table LEFT JOIN MTP_master ON problems_table.niin = MTP_master.NIIN

WHERE (((MTP_master.Shop) Like [forms]![switchboard]![shop select].[value] & "*"));