Crosstab is missing data from underlying table

  • Thread starter Alexus12 via AccessMonster.com
  • Start date
A

Alexus12 via AccessMonster.com

Crosstab is missing data from underlying table
while NO WHERE/HAVING clauses exist!
(Issue tested on Access97 SR1 and 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

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?..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab is missing data from underlying table 3
Create table in code from crosstab type query 3
Getting Underlying Data from a Pivot Table Cell 1
OWC11 pivot table export to excel fail: missing tag row (seems to 0
Using results from a Sub Query in a Crosstab Query 4
Missing data, restart app data is there 0
Pivot Table Underlying Data Missing 1
Calling a module from another module 5

Top