Crosstab is missing data from underlying table

[Crosstab is missing data]

Crosstab is missing data from underlying table
while NO WHERE/HAVING clauses exist!
(Issue tested on Access97 SR1 & SR2):

this is WRONG results (jpeg shot):
http://www.sql.ru/forum/actualfile.aspx?id=1495855

this is true results NEEDED (jpeg shot):
http://www.sql.ru/forum/actualfile.aspx?id=1495856

And here is part of database representing error (click to download):
http://www.sql.ru/forum/actualfile.aspx?id=1495860

Please help to understand WHY we get into this error
and ho to get rid of it

 

[Michel Walsh]

Hi,

I don't get the wrong result with Access 2003. Your two crosstabs
produce the same result ( the "desired" one). Have you applied all the known
and applicable patches to your system?


Hoping it may help,
Vanderghast, Access MVP


"Crosstab is missing data" <Crosstab is missing
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Alexus12]

Have you applied all the known

and applicable patches to your system?

I have it tested on both A97 SR1 and A97 SR2
with all SP for Jet 3.51 (which is used in A97 by the way)
and I have the same error reports from several forums
where this sample base was tested in Access97

Could it be the problem of data (language characters, etc)
or serious bug in Jet?
Because if I calculate this crosstab on table IDs instead of text fields -
it works fine.
But as soon as I try to use text - it produces errors!

How to be confident in Crosstabs?..

 

[Alexus12]

UP UP UP UP UP UP UP UP UP UP UP UP