1. 8_9GF_Qty

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

FROM MTP_master INNER JOIN dbo_requisition ON MTP_master.NIIN = dbo_requisition.NIIN

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, [5_data].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, [5_data].rqd AS NRO, [5_data].BO_Tot AS [Total Backorders], [5_data].MICAP AS MICAPs, [5_data].OWO AS OWO, Null AS Color, Null AS overall, [5_data].YBQ, [5_data].Prod, [5_data].QDR, problems_table.Forecast, [5_data].FSC, [5_data].MMAC, [5_data].NIIN, problems_table.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.Cont_Prod, 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, [5_data].RSP_A, [5_data].CSI_OH, [5_data].[BOA+YBQ], 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]

FROM 5_data INNER JOIN problems_table ON [5_data].NIIN = problems_table.niin

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

3. Daily MICAP and BO Report

SELECT MTP_master.Shop, MTP_master.[CNTL-NR] AS [Cntrl#], MTP_master.FSC, MTP_master.NIIN, MTP_master.MMAC AS MC, dbo_MasterQueryTable.Noun, MTP_master.ORG, MTP_master.MICAP, MTP_master.[BACKORDERS-JCS] AS JCS, MTP_master.YBQ, 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, MTP_master.Prod, 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 INNER JOIN MTP_master ON dbo_MasterQueryTable.NIIN = MTP_master.NIIN

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, dbo_Actl2MstrNIIN.OOU_Code

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] & "*"));