Data type mismatch

Question

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 [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;

Thank you!

Tonya

Answer 1

I believe it may mean that some of your PK/FKs aren't the same datatype on your joins. You should check them, and if you need to you can convert them in the query like CStr([Product Header].Entity) just to make them match if you need to.

Answer 2

HTHP is probably right. Additionally, Year is a reserved word and as such should never be used as an object name. https://support.office.com/en-us/article/Access-2007-reserved-words-and-symbols-E33EB3A9-8BAA-4335-9F57-DA237C63EABE

---

-Tom. Microsoft Access MVP

Answer 3

It also occurred to me that you could be trying to Sum() data types that aren't sum-able, check those data types also.