By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,392 Members | 1,507 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,392 IT Pros & Developers. It's quick & easy.

Error on a CrossTab

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

Expand|Select|Wrap|Line Numbers
  1. 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]
  2. FROM [CIO Scorecard All Open Risk]
  3. WHERE ((([CIO Scorecard All Open Risk].Database)<>"CM Open Risk") AND (([CIO Scorecard All Open Risk].[Target Date])<[Reporting date]))
  4. 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?


Sep 4 '07 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,396
What do you mean by "attach a crosstab"?
Sep 4 '07 #2

Expert Mod 10K+
P: 12,396
Change your variables to parameters.
Sep 5 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.