Access DB Pass through query not working

[Inspirz]

Hi,I created a pass through query in Access (please see below query #1) and I get a failure "Data Type "m" does not match a defined Type name." I'm creating a pass through because the Tetadata view that has this information has millions of rows and I just need a rolling three months. When I create a direct link query and then select query off of that, it works, (please see query #2 below) but it won't work if I create a pass through query.
Could someone please let me know why it's failing? I'm
query #1SELECT PlanCapacityId, PlantName, DeprecatedPlantName, PlanId,
TimePeriodId, CapacityCode, SystemName, ModuleName, PETROCapacityDescription,
RowrhsMin, RowrhsMax, Used, LimitCost, StartDateTime, EndDateTime,
CaseName, BaseCase, NAME, PlanType, EffectiveStartDate, EffectiveEndDate
FROM SCM_REFINERY_FUNCTIONAL_VW_P.vwLPPlanCapacityDetai l
where plantname = 'ESE' and startdatetime between (DateAdd("m",-3,Date())) And Date()))
query #2SELECT [PETRO Capacity Detail].PlanCapacityId, [PETRO Capacity Detail].PlantName, [PETRO Capacity Detail].DeprecatedPlantName, [PETRO Capacity Detail].PlanId, [PETRO Capacity Detail].TimePeriodId, [PETRO Capacity Detail].CapacityCode, [PETRO Capacity Detail].SystemName, [PETRO Capacity Detail].ModuleName, [PETRO Capacity Detail].PETROCapacityDescription, [PETRO Capacity Detail].RowrhsMin, [PETRO Capacity Detail].RowrhsMax, [PETRO Capacity Detail].Used, [PETRO Capacity Detail].LimitCost, [PETRO Capacity Detail].StartDateTime, [PETRO Capacity Detail].EndDateTime, [PETRO Capacity Detail].CaseName, [PETRO Capacity Detail].BaseCase, [PETRO Capacity Detail].NAME, [PETRO Capacity Detail].PlanType, [PETRO Capacity Detail].EffectiveStartDate, [PETRO Capacity Detail].EffectiveEndDate
FROM [PETRO Capacity Detail]
GROUP BY [PETRO Capacity Detail].PlanCapacityId, [PETRO Capacity Detail].PlantName, [PETRO Capacity Detail].DeprecatedPlantName, [PETRO Capacity Detail].PlanId, [PETRO Capacity Detail].TimePeriodId, [PETRO Capacity Detail].CapacityCode, [PETRO Capacity Detail].SystemName, [PETRO Capacity Detail].ModuleName, [PETRO Capacity Detail].PETROCapacityDescription, [PETRO Capacity Detail].RowrhsMin, [PETRO Capacity Detail].RowrhsMax, [PETRO Capacity Detail].Used, [PETRO Capacity Detail].LimitCost, [PETRO Capacity Detail].StartDateTime, [PETRO Capacity Detail].EndDateTime, [PETRO Capacity Detail].CaseName, [PETRO Capacity Detail].BaseCase, [PETRO Capacity Detail].NAME, [PETRO Capacity Detail].PlanType, [PETRO Capacity Detail].EffectiveStartDate, [PETRO Capacity Detail].EffectiveEndDate
HAVING ((([PETRO Capacity Detail].PlantName)="ESE") AND (([PETRO Capacity Detail].StartDateTime) Between (DateAdd("m",-3,Date())) And Date()))
ORDER BY [PETRO Capacity Detail].StartDateTime DESC;

[Inspirz]

i got it... I googled it. I needed to add interval.

[CJ_London]

I suspect it's because you are using access sql, you need to use the sql for the target rdbms (e.g. Teradata). Suggest look at your date fields and functions and compare with the Teradata equivalents

You also have field names like 'NAME' which is a reserved word - at the very least you should put it into square brackets

not sure why you are grouping in the second query since you are not using aggregation - suggest use SELECT DISTINCT instead.

recommend in the future you use code tags to highlight your code - it's pretty unreadable.