1.  8_9GF_Qty

The having statement was removed (HAVING (((dbo_requisition.project_code) Like [Enter Project code] & "*") AND ((MTP_master.Shop) Like [forms]![switchboard]![shop select] & "*"))).  Results in SQL Server and Access are the same.

SELECT     TOP (100) PERCENT dbo.MTP_master.NIIN, SUM(dbo.dbo_requisition.quantity) AS SumOfquantity, dbo.dbo_requisition.project_code,

                      dbo.MTP_master.Shop

FROM         dbo.MTP_master INNER JOIN

                      dbo.dbo_requisition ON dbo.MTP_master.NIIN = dbo.dbo_requisition.NIIN

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

ORDER BY SumOfquantity DESC


 

2.  Chart

The where statement was excluded (WHERE ((([5_data].Shop) Like [forms]![switchboard]![shop select].[value] & "*"));) the results are the same in SQL Server and Access.  The SQL Server Statements are the same otherwise.

SELECT     dbo.[5_data].Master_NSN AS nsn, dbo.[5_data].Shop AS PSSD, dbo.[5_data].Noun, dbo.[5_data].[CNTL-NR] AS PDN,

                      dbo.[5_data].F_days AS [Flow Days], dbo.[5_data].WL, dbo.[5_data].CSI_OH AS [09 Assets], dbo.[5_data].CRI, dbo.[5_data].G019C,

                      dbo.[5_data].rqd AS NRO, dbo.[5_data].BO_Tot AS [Total Backorders], dbo.[5_data].MICAP AS MICAPs, dbo.[5_data].OWO, NULL AS Color, NULL

                      AS overall, dbo.[5_data].YBQ, dbo.[5_data].Prod, dbo.[5_data].QDR, dbo.problems_table.Forecast, dbo.[5_data].FSC, dbo.[5_data].MMAC,

                      dbo.[5_data].NIIN, dbo.problems_table.TMS, dbo.problems_table.Forecast AS Expr2, dbo.problems_table.Act_FD, dbo.problems_table.AWP_F,

                      dbo.problems_table.[Parts Problem], dbo.problems_table.Other, dbo.problems_table.Cont_Prod, dbo.problems_table.[Equip 1],

                      dbo.problems_table.[Equip 2], dbo.problems_table.[Equip 3], dbo.problems_table.[Equip 4], dbo.problems_table.[Equip 5],

                      dbo.problems_table.[Equip 6], dbo.problems_table.P_N, dbo.problems_table.Contract_OWO, dbo.[5_data].SOS, dbo.[5_data].ORG,

                      dbo.problems_table.Cont_Prod AS Expr3, dbo.problems_table.Personnel, dbo.[5_data].POS_A, dbo.[5_data].Item_Count, dbo.[5_data].Carc_Avail,

                      dbo.[5_data].Parts_avail, dbo.[5_data].Hours_Avail, dbo.[5_data].Funds_Avail, dbo.[5_data].Sort_Value, dbo.[5_data].Pushed, dbo.[5_data].RSP_A,

                      dbo.[5_data].CSI_OH, dbo.[5_data].[BOA+YBQ], dbo.problems_table.Cont_forecast, dbo.problems_table.contract_cri, dbo.problems_table.[I&S],

                      dbo.[5_data].Target, dbo.problems_table.Awp_G, dbo.problems_table.[AWP Days], dbo.[5_data].NAME, dbo.[5_data].PHONE,

                      dbo.[5_data].FirstQuarterPastRepair, dbo.[5_data].SecondQuarterPastRepair, dbo.[5_data].ThirdQuarterPastRepair,

                      dbo.[5_data].FirstQuarterPastAddlRepair, dbo.[5_data].SecondQuarterPastAddlRepair, dbo.[5_data].ThirdQuarterPastAddlRepair, dbo.[5_data].RO,

                      dbo.[5_data].[Base Assets]

FROM         dbo.[5_data] INNER JOIN

                      dbo.problems_table ON dbo.[5_data].NIIN = dbo.problems_table.niin


 

3.  Daily MICAP and BO Report

The where statement was removed (WHERE (((MTP_master.Shop) Like [forms]![switchboard]![shop select].[value] & "*")))  Data retrievals are identical.

 

SELECT     TOP (100) PERCENT dbo.MTP_master.Shop, dbo.MTP_master.[CNTL-NR] AS Cntrl#, dbo.MTP_master.FSC, dbo.MTP_master.NIIN,

                      dbo.MTP_master.MMAC AS MC, dbo.dbo_MasterQueryTable.Noun, dbo.MTP_master.ORG, dbo.MTP_master.MICAP,

                      dbo.MTP_master.[BACKORDERS-JCS] AS JCS, dbo.MTP_master.YBQ, dbo.MTP_master.HP_Total AS [700s], dbo.MTP_master.BO_Tot AS [Total BOs],

                      dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-A] AS [A Cond], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Z] AS [Z Cond],

                      dbo.MTP_master.OWO, dbo.MTP_master.Prod, dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F Cond],

                      dbo.MTP_master.Carc_Avail AS Carc, dbo.MTP_master.Parts_avail AS Parts, dbo.MTP_master.Hours_Avail AS Hours,

                      dbo.MTP_master.Funds_Avail AS Funds

FROM         dbo.dbo_MasterQueryTable INNER JOIN

                      dbo.MTP_master ON dbo.dbo_MasterQueryTable.NIIN = dbo.MTP_master.NIIN

ORDER BY dbo.MTP_master.Shop, Cntrl#

4.  I&S

Only works in SQL Server and Access after the where statement being removed, results are the same.

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

SELECT     dbo.dbo_Actl2MstrNIIN.Actl_NIIN, dbo.dbo_Actl2MstrNIIN.Mstr_NIIN, dbo.dbo_Actl2MstrNIIN.OOU_Code

FROM         dbo.MTP_master LEFT OUTER JOIN

                      dbo.dbo_Actl2MstrNIIN ON dbo.MTP_master.NIIN = dbo.dbo_Actl2MstrNIIN.InS_NIIN


 

5.  Select Problem_items by PSSD

The where statement was removed (WHERE (((MTP_master.Shop) Like [forms]![switchboard]![shop select].[value] & "*"));), Results are the same, but had to rewrite/Change the Query to get matching results.

 

SELECT     dbo.problems_table.niin, dbo.problems_table.P_N, dbo.problems_table.TMS, dbo.problems_table.Forecast, dbo.problems_table.Cont_forecast,

                      dbo.problems_table.Act_FD, dbo.problems_table.AWP_F, dbo.problems_table.Contract_OWO, dbo.problems_table.[Parts Problem],

                      dbo.problems_table.Other, dbo.problems_table.Cont_Prod, dbo.problems_table.[Equip 1], dbo.problems_table.[Equip 2], dbo.problems_table.[Equip 3],

                      dbo.problems_table.[Equip 4], dbo.problems_table.[Equip 5], dbo.problems_table.[Equip 6], dbo.problems_table.Personnel,

                      dbo.problems_table.contract_cri, dbo.problems_table.[I&S], dbo.problems_table.Awp_G, dbo.problems_table.[AWP Days],

                      dbo.problems_table.SSMA_TimeStamp, dbo.MTP_master.Shop

FROM         dbo.MTP_master INNER JOIN

                      dbo.problems_table ON dbo.MTP_master.NIIN = dbo.problems_table.niin