Code:
SELECT [FIBER TRUNKS].[(EEFGH)], [FIBER TRUNKS].Color, [FIBER TRUNKS].[Fiber Count], [FIBER TRUNKS].[Fiber Type], [FIBER TRUNKS].[Cable Color], [FIBER TRUNKS].Description, [FIBER TRUNKS].[Corning Part #], "" AS Corning_MatNum, 1.11 AS Corning_Inv, "" AS Corning_units, 1.11 AS Corning_StdPrice, [FIBER TRUNKS].[Superior Part #], "" AS Superior_MatNum, 1.11 AS Superior_Inv, "" AS Superior_units, 1.11 AS Superior_StdPrice, [FIBER TRUNKS].[AFL Part #], "" AS AFL_MatNum, 1.11 AS AFL_Inv, "" AS AFL_units, 1.11 AS AFL_StdPrice, [FIBER TRUNKS].[TLC Part #], "" AS TLC_MatNum, 1.11 AS TLC_Inv, "" AS TLC_units, 1.11 AS TLC_StdPrice, [FIBER TRUNKS].[OCC Part #], "" AS OCC_MatNum, 1.11 AS OCC_Inv, "" AS OCC_units, 1.11 AS OCC_StdPrice, [FIBER TRUNKS].[OFS Part #], "" AS OFS_MatNum, 1.11 AS OFS_Inv, "" AS OFS_units, 1.11 AS OFS_StdPrice, [FIBER TRUNKS].[Draka Part #], "" AS DrakaPrysmian_MatNum, 1.11 AS DrakaPrysmian_Inv, "" AS DrakaPrysmian_units, 1.11 AS DrakaPrysmian_StdPrice, [FIBER TRUNKS].[Hitachi Part #], "" AS Hitachi_MatNum, 1.11 AS Hitachi_Inv, "" AS Hitachi_units, 1.11 AS Hitachi_StdPrice, [FIBER TRUNKS].[Berktek Part #], "" AS Berktek_MatNum, 1.11 AS Berktek_Inv, "" AS Berktek_units, 1.11 AS Berktek_StdPrice, [FIBER TRUNKS].[Commscope Part #], "" AS Commscope_MatNum, 1.11 AS Commscope_Inv, "" AS Commscope_units, 1.11 AS Commscope_StdPrice INTO MasterTrunksFROM [FIBER TRUNKS];
query creates, I notice that the data type for Draka Part # is Short Text instead of Yes/No.