问题描述
早上好。我查看了几篇帖子，大多数都有错误代码，而我没有。或者，在其他示例中，我没有看到它与我的问题有什么关系。自从我使用Access以来已经有好几年了 - 我不得不说我的技能是非常生锈的
。这是我的代码 - 任何帮助都会非常受欢迎！
Good morning. I have looked through several posts and most have an error code with this whereas I do not. Or, in other examples, I didn't see how it related to my issue. Its been several years since I have worked with Access - I have to say my skills are extremely rusty. Here's my code - any help would be GREATLY APPRECIATED!
SELECT [生产标题] .Entity，[生产标题]。[县名] ，[生产标题]。[生产区域名称]，[年产量]。年，总和（[年产量]。[年度液体]）AS [SumOfAnnual Liquid]，Sum（[年产量]。[年度气体]）AS [SumOfAnnual
Gas]，Sum（[年产量]。[年度水]）AS [SumOfAnnual Water]
FROM（[生产标题] INNER JOIN [年产量] ON [生产标题] ]。[实体] = [年度生产]。[实体]）内部联合[生产摘要] ON [生产标题]。实体= [生产摘要]。实体
GROUP BY [生产标题]。实体，[生产标题]。[县名]，[生产标题]。[生产区域名称]，[年产量]。年份b
生产标题订单。实体，[年产量] 。年;
SELECT [Production Header].Entity, [Production Header].[County Name], [Production Header].[Prod Zone Name], [Annual Production].Year, Sum([Annual Production].[Annual Liquid]) AS [SumOfAnnual Liquid], Sum([Annual Production].[Annual Gas]) AS [SumOfAnnual Gas], Sum([Annual Production].[Annual Water]) AS [SumOfAnnual Water]
FROM ([Production Header] INNER JOIN [Annual Production] ON [Production Header].[Entity] = [Annual Production].[Entity]) INNER JOIN [Production Abstract] ON [Production Header].Entity = [Production Abstract].Entity
GROUP BY [Production Header].Entity, [Production Header].[County Name], [Production Header].[Prod Zone Name], [Annual Production].Year
ORDER BY [Production Header].Entity, [Annual Production].Year;
谢谢！
Tonya
推荐答案
这篇关于数据类型不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！