Data is missing in crosstab report

[Kaur]

Hi,

I have created a report based on a crosstab query in MS Access 2000.
The query pulls data
for all the surveys with question, subquestion along with the response
percentage. The report is prepared from the sample taken from the below

link:
http://www.invisibleinc.com/


The problem I am facing is that the response percentage for some of the

questions do not show up. When I check the query the response
percentage is there but for some reason it does not show up for some of

the responses in the report. If I open the report and go in the design
view of the report and from there select the query to run from the
control source of the report and come back to the report preview some
of the missing data gets populated But there is still some missing
data. I am going nuts trying to figure out what is causing the missing
data.


I would appreciate any help.

 

[Duane Hookom]

Maybe you could tell us which of my crosstab reports you are using and
possibly the SQL view of your report's record source. If the report is not
based directly on the crosstab, please provide the sql view of the crosstab.