1 / 16

Issues with MAN_DREP

Issues with MAN_DREP. Cannot fully access. x 6_Goal1

ronni
Télécharger la présentation

Issues with MAN_DREP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Issues with MAN_DREP Cannot fully access x 6_Goal1 SELECT MTP_master.Shop, MTP_master.NIIN, MTP_master.FSC, MTP_master.Noun, MTP_master.MMAC, MTP_master.BO_Tot, MTP_master.G019C, MTP_master.QDR, ((mtp_master.BO_tot/4)+mtp_master.QDR) AS [BO/5+QDR], IIf([PSSDs] Is Null,[EXP_goal],mtp_master.G019C) AS Target, IIf([bo/5+QDR]<0,mtp_master.QDR,[bo/5+qdr]) AS EXP_Goal, MTP_master.[CNTL-NR], LIP_PBA_PSSDs.[New PSSD] AS PSSDs, targets.Target AS [Prev Target], past_repair.FirstQuarterPastRepair AS [Prev Qtr Org Repair], past_repair.FirstQuarterPastAddlRepair AS [Prev Qtr Addl Repair] FROM ((MTP_master LEFT JOIN LIP_PBA_PSSDs ON MTP_master.Shop=LIP_PBA_PSSDs.[New PSSD]) LEFT JOIN past_repair ON MTP_master.NIIN=past_repair.NIIN) INNER JOIN targets ON MTP_master.NIIN=targets.NIIN; 6_Goal1 SELECT MTP_master.Shop, MTP_master.NIIN, MTP_master.FSC, MTP_master.Noun, MTP_master.MMAC, MTP_master.BO_Tot, MTP_master.G019C, MTP_master.QDR, ((mtp_master.BO_tot/4)+mtp_master.QDR) AS [BO/5+QDR], IIf([PSSDs] Is Null,[EXP_goal],mtp_master.G019C) AS Target, IIf([bo/5+QDR]<0,mtp_master.QDR,[bo/5+qdr]) AS EXP_Goal, MTP_master.[CNTL-NR], LIP_PBA_PSSDs.[New PSSD] AS PSSDs, targets.Target AS [Prev Target], past_repair.FirstQuarterPastRepair AS [Prev Qtr Org Repair], past_repair.FirstQuarterPastAddlRepair AS [Prev Qtr Addl Repair] FROM ((MTP_master LEFT JOIN LIP_PBA_PSSDs ON MTP_master.Shop=LIP_PBA_PSSDs.[New PSSD]) LEFT JOIN past_repair ON MTP_master.NIIN=past_repair.NIIN) LEFT JOIN targets ON MTP_master.NIIN=targets.NIIN;

  2. 1a_MTP_master Query in Access SELECT dbo_RepairData.NIIN, dbo_RepairData.Repaired AS Prod, dbo_RepairData.Quarter FROM dbo_RepairData, [Date] WHERE (((dbo_RepairData.Quarter)=[date].[current qtr])); 1a_MTP_master Query in SQL Server 2005 SELECT dbo.dbo_RepairData.NIIN, dbo.dbo_RepairData.Repaired AS Prod, dbo.dbo_RepairData.Quarter FROM dbo.dbo_RepairData INNER JOIN dbo.date ON dbo.dbo_RepairData.Quarter = dbo.date.[Current Qtr] [date].[current qtr] Don’t know what these do, did not include in SQL Server.

  3. 4_NRO Query in Access SELECT dbo_spt_results.NIIN, Count(dbo_spt_results.NIIN) AS CountOfNIIN FROM dbo_spt_results GROUP BY dbo_spt_results.NIIN; 4_NRO Query in SQL Server 2005 SELECT NIIN, COUNT(NIIN) AS CountOfNIIN FROM dbo.dbo_spt_results GROUP BY NIIN

  4. 4A_I&S in Access Different Between the 2 versions Possibly SELECT MTP_master.NIIN, [I&S].Mstr_NIIN, [I&S].Actl_NIIN, [I&S].OOU_Code FROM MTP_master INNER JOIN [I&S] ON MTP_master.NIIN = [I&S].Mstr_NIIN; 4A_I&S Query in SQL Server 2005 SELECT dbo.MTP_master.NIIN, dbo.[I&S].Actl_NIIN, dbo.[I&S].Mstr_NIIN, dbo.[I&S].OOU_Code FROM dbo.MTP_master INNER JOIN dbo.[I&S] ON dbo.MTP_master.NIIN = dbo.[I&S].Mstr_NIIN

  5. 5_data in Access Different Between the 2 versions SELECT DISTINCT MTP_master.NIIN, MTP_master.FSC, MTP_master.Noun, MTP_master.MMAC, MTP_master.SOR, MTP_master.[CNTL-NR], MTP_master.Shop, MTP_master.QDR, MTP_master.Prod, MTP_master.MICAP, MTP_master.YBQ, MTP_master.BO_Tot, MTP_master.F_days, MTP_master.RSP_A, MTP_master.POS_A AS POS_A, MTP_master.CSI_OH, MTP_master.G019C, MTP_master.Master_NSN, MTP_master.CRI, MTP_master.OWO, MTP_master.AWP_G, [4_nro].CountOfNIIN AS rqd, MTP_master.SOS, MTP_master.Item_Count, MTP_master.Carc_Avail, MTP_master.Parts_avail, MTP_master.Hours_Avail, MTP_master.Funds_Avail, MTP_master.Sort_Value, MTP_master.Pushed, working_level.w_level, MTP_master.AIS_WL, IIf([w_level] Is Null,[AIS_WL],[W_level]) AS WL, MTP_master.HP_Total, MTP_master.[BACKORDERS-JCS], [YBQ]+[backorders-jcs]+[hp_total] AS [BOA+YBQ], targets.Target, MTP_master.ORG, MTP_master.NAME, MTP_master.PHONE, Past_repair.FirstQuarterPastRepair, Past_repair.SecondQuarterPastRepair, Past_repair.ThirdQuarterPastRepair, Past_repair.FirstQuarterPastAddlRepair, Past_repair.SecondQuarterPastAddlRepair, Past_repair.ThirdQuarterPastAddlRepair, MTP_master.[Base Assets], MTP_master.RO FROM ((((MTP_master LEFT JOIN 4_nro ON MTP_master.NIIN = [4_nro].NIIN) LEFT JOIN working_level ON MTP_master.NIIN = working_level.NIIN) LEFT JOIN targets ON MTP_master.NIIN = targets.NIIN) LEFT JOIN [count subs] ON MTP_master.NIIN = [count subs].Mstr_NIIN) LEFT JOIN Past_repair ON MTP_master.NIIN = Past_repair.NIIN; 5_data Query in SQL Server 2005 SELECT dbo.MTP_master.NIIN, dbo.MTP_master.FSC, dbo.MTP_master.Noun, dbo.MTP_master.MMAC, dbo.MTP_master.SOR, dbo.MTP_master.[CNTL-NR], dbo.MTP_master.Shop, dbo.MTP_master.QDR, dbo.MTP_master.Prod, dbo.MTP_master.MICAP, dbo.MTP_master.YBQ, dbo.MTP_master.BO_Tot, dbo.MTP_master.F_days, dbo.MTP_master.RSP_A, dbo.MTP_master.POS_A, dbo.MTP_master.CSI_OH, dbo.MTP_master.G019C, dbo.MTP_master.Master_NSN, dbo.MTP_master.CRI, dbo.MTP_master.OWO, dbo.MTP_master.AWP_G, dbo.MTP_master.SOS, dbo.MTP_master.Item_Count, dbo.MTP_master.Carc_Avail, dbo.MTP_master.Parts_avail, dbo.MTP_master.Hours_Avail, dbo.MTP_master.Funds_Avail, dbo.MTP_master.Sort_Value, dbo.MTP_master.Pushed, dbo.working_level.w_level, dbo.MTP_master.AIS_WL, 'WL: IIf([w_level] Is Null,[AIS_WL],[W_level])' AS WL, dbo.MTP_master.HP_Total, dbo.MTP_master.[BACKORDERS-JCS], 'BOA+YBQ: [YBQ]+[backorders-jcs]+[hp_total]' AS [BOA+YBQ], dbo.targets.Target, dbo.MTP_master.NAME, dbo.MTP_master.PHONE, dbo.past_repair.FirstQuarterPastRepair, dbo.past_repair.SecondQuarterPastRepair, dbo.past_repair.ThirdQuarterPastRepair, dbo.past_repair.FirstQuarterPastAddlRepair, dbo.past_repair.SecondQuarterPastAddlRepair, dbo.past_repair.ThirdQuarterPastAddlRepair, dbo.MTP_master.[Base Assets], dbo.MTP_master.RO, dbo.MTP_master.ORG, dbo.[4_NRO].CountOfNIIN AS rqd FROM dbo.MTP_master INNER JOIN dbo.past_repair ON dbo.MTP_master.NIIN = dbo.past_repair.NIIN INNER JOIN dbo.working_level ON dbo.MTP_master.NIIN = dbo.working_level.NIIN INNER JOIN dbo.[4_NRO] ON dbo.MTP_master.NIIN = dbo.[4_NRO].NIIN INNER JOIN dbo.[count subs] ON dbo.MTP_master.NIIN = dbo.[count subs].Mstr_NIIN INNER JOIN dbo.targets ON dbo.MTP_master.NIIN = dbo.targets.NIIN WL: IIf([w_level] Is Null,[AIS_WL],[W_level]) and BOA+YBQ: [YBQ]+[backorders-jcs]+[hp_total] Don’t know what these do, did not include in SQL Server.

  6. 8_9GF_Qty in Access 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; 8_9GF_Qty Query in SQL Server 2005 SELECT TOP (100) PERCENT dbo.MTP_master.NIIN, SUM(dbo.dbo_requisition.quantity) AS Expr1, dbo.dbo_requisition.project_code, dbo.MTP_master.Shop FROM dbo.dbo_requisition INNER JOIN dbo.MTP_master ON dbo.dbo_requisition.NIIN = dbo.MTP_master.NIIN GROUP BY dbo.MTP_master.NIIN, dbo.dbo_requisition.project_code, dbo.MTP_master.Shop ORDER BY SUM(dbo.dbo_requisition.quantity) DESC Like [Enter Project code] & "*“ and Like [forms]![switchboard]![shop select] & "*" Don’t know what these do, did not include in SQL Server.

  7. chart in Access Different Between the 2 versions 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] & "*")); chart in SQL Server 2005 SELECT dbo.[5_data].Master_NSN, dbo.[5_data].Shop, dbo.[5_data].Noun, dbo.[5_data].[CNTL-NR], dbo.[5_data].F_days, dbo.[5_data].WL, dbo.[5_data].CSI_OH, dbo.[5_data].CRI, dbo.[5_data].G019C, dbo.[5_data].RSP_A, dbo.[5_data].POS_A, dbo.[5_data].OWO, dbo.[5_data].AWP_G, dbo.[5_data].rqd, dbo.[5_data].BO_Tot, dbo.[5_data].MICAP, 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.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.Personnel, 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].[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 AS Expr1, 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 Like [forms]![switchboard]![shop select].[value] & "*“ Don’t know what these do, did not include in SQL Server.

  8. count subs Query in Access SELECT [temp table subs in 2 column format].Mstr_NIIN, [temp table subs in 2 column format].Actl_NIIN, Count([temp table subs in 2 column format].Mstr_NIIN) AS CountOfMstr_NIIN FROM [temp table subs in 2 column format] INNER JOIN [temp table subs in 2 column format] AS [temp table subs in 2 column format_1] ON [temp table subs in 2 column format].Mstr_NIIN = [temp table subs in 2 column format_1].Mstr_NIIN GROUP BY [temp table subs in 2 column format].Mstr_NIIN, [temp table subs in 2 column format].Actl_NIIN; count subs Query in SQL Server 2005 SELECT dbo.[temp table subs in 2 column format].Mstr_NIIN, dbo.[temp table subs in 2 column format].Actl_NIIN, COUNT(dbo.[temp table subs in 2 column format].Mstr_NIIN) AS CountOfMstr_NIIN FROM dbo.[temp table subs in 2 column format] INNER JOIN dbo.[temp table subs in 2 column format] AS [temp table subs in 2 column format_1] ON dbo.[temp table subs in 2 column format].Mstr_NIIN = [temp table subs in 2 column format_1].Mstr_NIIN GROUP BY dbo.[temp table subs in 2 column format].Mstr_NIIN, dbo.[temp table subs in 2 column format].Actl_NIIN

  9. Daily MICAP and BO Report Query in Access Different Between the 2 versions 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]; Daily MICAP and BO Report in SQL Server 2005 SELECT TOP (100) PERCENT dbo.MTP_master.Shop, dbo.MTP_master.[CNTL-NR], dbo.MTP_master.FSC, dbo.MTP_master.NIIN, dbo.MTP_master.MMAC, dbo.dbo_MasterQueryTable.Noun, dbo.MTP_master.ORG, dbo.MTP_master.MICAP, dbo.MTP_master.[BACKORDERS-JCS], dbo.MTP_master.YBQ, dbo.MTP_master.HP_Total, dbo.MTP_master.BO_Tot, dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-A], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Z], dbo.MTP_master.OWO, dbo.MTP_master.Prod, dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F], dbo.MTP_master.Carc_Avail, dbo.MTP_master.Parts_avail, dbo.MTP_master.Hours_Avail, dbo.MTP_master.Funds_Avail FROM dbo.dbo_MasterQueryTable INNER JOIN dbo.MTP_master ON dbo.dbo_MasterQueryTable.NIIN = dbo.MTP_master.NIIN ORDER BY dbo.MTP_master.Shop, dbo.MTP_master.[CNTL-NR] Like [forms]![switchboard]![shop select].[value] & "*“ Don’t know what these do, did not include in SQL Server.

  10. I&S Query in Access Different Between the 2 versions 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])); I&S Report in SQL Server 2005 SELECT dbo.dbo_Actl2MstrNIIN.Actl_NIIN, dbo.dbo_Actl2MstrNIIN.Mstr_NIIN, dbo.dbo_Actl2MstrNIIN.OOU_Code FROM dbo.dbo_Actl2MstrNIIN INNER JOIN dbo.MTP_master ON dbo.dbo_Actl2MstrNIIN.Mstr_NIIN = dbo.MTP_master.NIIN [forms]![problems_table].[niin] Don’t know what these do, did not include in SQL Server.

  11. MTAA BO BURNDOWN DATA Query in Access Different Between the 2 versions SELECT MTP_master.[CNTL-NR] AS [Cntrl#], MTP_master.FSC, MTP_master.NIIN, MTP_master.MMAC AS MC, MTP_master.Noun, MTP_master.MICAP, MTP_master.[BACKORDERS-JCS] AS JCS, MTP_master.BO_Tot AS [Total BO], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-A] AS [A Cond], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Z] AS [Z cond], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F Cond], MTP_master.OWO, MTP_master.Prod, MTP_master.Carc_Avail AS Carc, MTP_master.Parts_avail AS Parts, MTP_master.Hours_Avail AS Hours, MTP_master.Funds_Avail AS Funds, MTP_master.ORG, MTP_master.NAME, MTP_master.PHONE FROM dbo_MasterQueryTable INNER JOIN MTP_master ON dbo_MasterQueryTable.NIIN = MTP_master.NIIN WHERE (((MTP_master.Shop) Like "MTAA**")) ORDER BY MTP_master.Shop, MTP_master.[CNTL-NR]; MTAA BO BURNDOWN DATA Report in SQL Server 2005 SELECT TOP (2147483647) WITH TIES 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.MTP_master.Noun, dbo.MTP_master.MICAP, dbo.MTP_master.[BACKORDERS-JCS] AS JCS, dbo.MTP_master.BO_Tot AS [Total BO], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-A] AS [A Cond], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Z] AS [Z cond], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F Cond], dbo.MTP_master.OWO, dbo.MTP_master.Prod, 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, dbo.MTP_master.ORG, dbo.MTP_master.NAME, dbo.MTP_master.PHONE FROM dbo.dbo_MasterQueryTable INNER JOIN dbo.MTP_master ON dbo.dbo_MasterQueryTable.NIIN = dbo.MTP_master.NIIN WHERE (dbo.MTP_master.Shop LIKE 'MTAA%%') ORDER BY dbo.MTP_master.Shop, Cntrl# Like "MTAA**" Don’t know what these do, did not include in SQL Server.

  12. MTAA DAILY MICAP AND BO REPORT Query in Access Different Between the 2 versions 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 "MTAA**")) ORDER BY MTP_master.Shop, MTP_master.[CNTL-NR]; MTAA DAILY MICAP AND BO REPORT in SQL Server 2005 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# Like "MTAA**“ Don’t know what these do, did not include in SQL Server.

  13. MTCC-MTCF Daily MICAP and BO Report Query in Access Different Between the 2 versions SELECT dbo_MasterQueryTable.Shop, MTP_master.[CNTL-NR] AS [Cntrl#], MTP_master.FSC, MTP_master.NIIN, MTP_master.MMAC AS MC, MTP_master.Noun, MTP_master.MICAP, MTP_master.YBQ, MTP_master.[BACKORDERS-JCS] AS JCS, 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], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F Cond], dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Y] AS [Y-Int], MTP_master.QDR, MTP_master.OWO, MTP_master.Prod, 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 (((dbo_MasterQueryTable.Shop) Like "MTCC**" Or (dbo_MasterQueryTable.Shop) Like "MTCF**")) ORDER BY dbo_MasterQueryTable.Shop, MTP_master.[CNTL-NR]; MTCC-MTCF Daily MICAP and BO Report in SQL Server 2005 SELECT TOP (100) PERCENT dbo.dbo_MasterQueryTable.Shop, dbo.MTP_master.[CNTL-NR] AS Cntrl#, dbo.MTP_master.FSC, dbo.MTP_master.NIIN, dbo.MTP_master.MMAC AS MC, dbo.MTP_master.Noun, dbo.MTP_master.MICAP, dbo.MTP_master.YBQ, dbo.MTP_master.[BACKORDERS-JCS] AS JCS, 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.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-F] AS [F cond], dbo.dbo_MasterQueryTable.[DEPOT-ASSETS-COND-Y] AS [Y-Int], dbo.MTP_master.QDR, dbo.MTP_master.OWO, dbo.MTP_master.Prod, 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.dbo_MasterQueryTable.Shop, Cntrl# Like "MTCC**" Or Like "MTCF**“ Don’t know what these do, did not include in SQL Server.

  14. Select Airframe by NIIN Query in Access SELECT dbo_ApplicationData.NIIN, dbo_ApplicationData.MDS FROM dbo_ApplicationData WHERE (((dbo_ApplicationData.MDS) Like "[A,B,C,F]*")); Select Airframe by NIIN in SQL Server 2005 SELECT NIIN, MDS FROM dbo.dbo_ApplicationData WHERE (MDS LIKE '[A,B,C,F]%')

  15. Select Problem_items by PSSD Query in Access 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] & "*")); Select Problem_items by PSSD in SQL Server 2005 SELECT dbo.MTP_master.Shop, dbo.MTP_master.NIIN AS Expr1, 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 FROM dbo.MTP_master INNER JOIN dbo.problems_table ON dbo.MTP_master.NIIN = dbo.problems_table.niin Like [forms]![switchboard]![shop select].[value] & "*" Don’t know what these do, did not include in SQL Server.

  16. subs against actual data Query in Access Different Between the 2 versions SELECT [5_data].NIIN, [count subs].Actl_NIIN, [count subs].CountOfMstr_NIIN FROM 5_data LEFT JOIN [count subs] ON [5_data].NIIN = [count subs].Mstr_NIIN GROUP BY [5_data].NIIN, [count subs].Actl_NIIN, [count subs].CountOfMstr_NIIN; subs against actual data in SQL Server 2005 SELECT dbo.[5_data].NIIN, dbo.[count subs].Actl_NIIN, dbo.[count subs].CountOfMstr_NIIN FROM dbo.[5_data] INNER JOIN dbo.[count subs] ON dbo.[5_data].NIIN = dbo.[count subs].Mstr_NIIN GROUP BY dbo.[5_data].NIIN, dbo.[count subs].Actl_NIIN, dbo.[count subs].CountOfMstr_NIIN

More Related