none
Data type mismatch RRS feed

  • 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

    Sunday, February 5, 2017 5:09 PM

All replies