Durval,
sim, Logo abaixo esta a consulta, no item em vermelho a função SUM não esta convertendo o caractere japonês para linguagem SQL. O que poderia estar ocasionando isso?
SELECT [PART LIST].SQ, オーダー.[Customer PN],
オーダー.[Used in IMV],
オーダー.PAI1403,
合計(オーダー.PAI1404) AS
合計のPAI1404,
オーダー.PAI1405,
オーダー.PAI1406,
オーダー.PAI1407,
オーダー.PAI1408, [PART LIST].FG_TRPN9, [PART LIST].Level, [PART LIST].TRPN9, [PART LIST].[Customer PN], [PART LIST].[Qty necessary for FG], [PART LIST].[Order Kbn], [PART LIST].XYZ,
[PART LIST].Supplier, [PART LIST].START, [PART LIST].END, [PART LIST].[PART NAME], [PART LIST].[201403], [PART LIST].[201404], [PART LIST].[201405], [PART LIST].[201406], [PART LIST].[201407], [PART LIST].[201408]
FROM [PART LIST] INNER JOIN オーダー ON [PART LIST].FG_TRPN9 =
オーダー.FG_TRPN9
GROUP BY [PART LIST].SQ, オーダー.[Customer PN],
オーダー.[Used in IMV],
オーダー.PAI1403,
オーダー.PAI1405,
オーダー.PAI1406,
オーダー.PAI1407,
オーダー.PAI1408, [PART LIST].FG_TRPN9, [PART LIST].Level, [PART LIST].TRPN9, [PART LIST].[Customer PN], [PART LIST].[Qty necessary for FG], [PART LIST].[Order Kbn], [PART LIST].XYZ,
[PART LIST].Supplier, [PART LIST].START, [PART LIST].END, [PART LIST].[PART NAME], [PART LIST].[201403], [PART LIST].[201404], [PART LIST].[201405], [PART LIST].[201406], [PART LIST].[201407], [PART LIST].[201408], [PART LIST].Death
HAVING ((([PART LIST].[Order Kbn])="PO") AND (([PART LIST].Death) Is Null))
ORDER BY [PART LIST].SQ;
