report build on cross-tab parameter query

  • Thread starter Thread starter Vadim
  • Start date Start date
V

Vadim

Hi folks,

I build report based on cross table query and everything was good until
I put parametrs in my query. The parameter is
Forms![FormName]!FieldName]. The query is working well but that
addition disabled my report. Now I am getting message - The microsoft
Jet database does not recognize " as a valid name or expresion. As soon
as I remove parameter report starts to work well. Any idea what I have
to fix?

Thanks,

Vadim
 
I am geting the same error when I try to use a crosstab query with paremeters.
Access help says that part of what I need to do is set the ColumnHeading
properties for the query that contains the parameters.
I have looked and cannot find any reference to these properties - I have
checked out the article you quoted and it does not mention column heading
properties.
Thanks for any help you can give.

Nicole

Tom Wickerath said:
Hi Vadim,

Please see this Microsoft KB article:

ACC2000: Error When Running Crosstab Query with a Parameter
http://support.microsoft.com/?id=209778

Note: This article applies equally well to Access 97, 2002 and 2003.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Vadim said:
Hi folks,

I build report based on cross table query and everything was good until
I put parametrs in my query. The parameter is
Forms![FormName]!FieldName]. The query is working well but that
addition disabled my report. Now I am getting message - The microsoft
Jet database does not recognize " as a valid name or expresion. As soon
as I remove parameter report starts to work well. Any idea what I have
to fix?

Thanks,

Vadim
Click to expand...
Click to expand...
 
Back
Top