Error on a CrossTab

[darkhat01]

I am getting an error when I try and attach a cross tab query to the following query:

SELECT [CIO Scorecard All Open Risk].IDCount, [CIO Scorecard All Open Risk].[Line of Business], [CIO Scorecard All Open Risk].[Criticality of Risk], [CIO Scorecard All Open Risk].Database, [CIO Scorecard All Open Risk].[Risk Assumed WO Mitigation], [CIO Scorecard All Open Risk].OTS, [CIO Scorecard All Open Risk].[Security Rep], [CIO Scorecard All Open Risk].PCI, [CIO Scorecard All Open Risk].[SOX FRC], [CIO Scorecard All Open Risk].Cabinet, [CIO Scorecard All Open Risk].[Cabinet Member], [CIO Scorecard All Open Risk].[Issue Description], [CIO Scorecard All Open Risk].[Mitigation Strategy], [CIO Scorecard All Open Risk].Owner, [CIO Scorecard All Open Risk].[Open Date], [CIO Scorecard All Open Risk].[Target Date], [CIO Scorecard All Open Risk].[Regulatory Type]
FROM [CIO Scorecard All Open Risk]
WHERE ((([CIO Scorecard All Open Risk].Database)<>"CM Open Risk") AND (([CIO Scorecard All Open Risk].[Target Date])<[Reporting date]))
ORDER BY [CIO Scorecard All Open Risk].[Target Date] DESC;

I know that it has something to do with using <[Reporting date] in the query. The error I am getting is "The Microsoft Jet database engine does not recognize '[Reporting date]' as a valid field name or expression."

If I run the Query it is fine and works the way it should.

Any ideas what I can do?

Thanks,

Darkhat01

[Rabbit]

What do you mean by "attach a crosstab"?

[Rabbit]

Change your variables to parameters.