report using crosstab query problem

[Asherman]

I have created a report from a crosstab query that will calculate how many
students attended a course during a particular half term period. As we have
not completed the last half term, how do I view the report with missing
parameters. The report states that all fields must be completed before the
report can be opened. If I try to open it from the design view it states
that the parameter [summer2] is not recognised. I know it has something to
do with query parameters but I am not sure of what to do. Is there an easy
way in design view rather than the complicated sounding ways in SQL that I
found on the web search?

 

[Golfinray]

Crosstab queries are not editable, therefore the report will not allow you to
add additional information without adding that information at the query
level. Each time you wanted to add additional data you would have to
completely rewrite the query. If possible, just do a plain select query and
then you can update the query anytime you have new data and the form will
automatically update also.

 

[KARL DEWEY]

I am not real sure due to your wording but I think you did not define your
parameters.
Open the query in design view and click on menu Query - Parameters. In the
window you must enter the exact names for your parameter and data type. If
the parameter is a prompt the best way is to copy and paste so there is no
typo.

 

[John Spencer]

Your crosstab query need to have the columns you need defined.

A problem with basing a report on a crosstab query is that the columns
that are returned can vary depending on the data being used to build the
crosstab.

If the columns that should be returned are constant - Summer1, Summer2,
Spring, Fall - you can open the query in design view.

Get the query properties
In the "property" column headings type in the column headings separated
by a comma (or semi-colon if that is your item separator).
Run the query and see if you get the desired results.



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================