Problem with reports based on crosstabs queries

[Big Pat]

I have a form which asks for two parameter dates and I want to run two reports, each one based on those start and end dates.

For each report, I have created:
· select query – works fine
· crosstab query, based on the select query – works fine
· Report, based on the crosstab query – PROBLEM

The Microsoft Jet database engine does not recognize ‘’ as a valid field name or expression.

Having read some other threads here (mainly Pat Hartmann replies), I defined the parameters in the crosstab queries as follows:

[Forms]![from Operations]![Reportdate1] - date/time format
[Forms]![from Operations]![Reportdate2] - date/time format

For good measure I defined them again in the select query, because I’m sure I read in one of the replies that they also have to be defined in any underlying queries.

But when I try to run either of the reports, I still get the message above. These reports worked OK when I designed them first, but at that point they were not based on any date parameters. As I said, both crosstab queries work OK, so I’m puzzled as to why the reports don’t. Do I need to redefine the parameters again, maybe in the report?

Grateful as always for help.

 

[Smart]

If memory serves me correctly whilst in the design of the cross tab you need to specify any parameters by going to the main menu click on query then on parameters. Not sure if this will solve the problem but it might

 

[Rich]

Have the crosstab query open when you re-design the Reports

 

[Big Pat]

If memory serves me correctly whilst in the design of the cross tab you need to specify any parameters by going to the main menu click on query then on parameters. Not sure if this will solve the problem but it might

No - I've already defined these parameters in both the crosstabs and the underlying select queries. Those queries all run OK, with no error messages

 

[Big Pat]

Have the crosstab query open when you re-design the Reports

Rich,

Do you mean have the crosstab open in DESIGN view, or in DATASHEET view? And do I need to redesign the reports from scratch, or can I just tweak something in the existing reports while the crosstab is open?

Pat

 

[JC3]

Hi

I was wondering whether there was any resolution to this since I am encountering a similar problem in that I have an Excel query based on my Access Crosstab Query.

The Excel query works fine if every account status is represented but if there are any missing then I get the Microsoft Jet Database error.

Any ideas?

 

[JC3]

Sorry worked out. Never knew about the Column Heading Property.

Thanks anyway.