crosstab query problem

  • Thread starter Thread starter Ramesh
  • Start date Start date
R

Ramesh

I use MSO2K. When i create a new crosstab query using the wizard, none
of the fields are getting listed in the tables. Similar problem I find
with Unmatched query wizard also. I have used both these wizards in the
past on the same system. Unable to recall anything which has been done
on the system which could have caused this problem.

I have to do a Detect and Repair operation. Problem still persists.

Any inputs on what could the problem be?

Thanks
Ramesh
 
Ive seen this happen before as well, certain fields just refuse to
show up in the wizards (seemingly always the ones i need!). I never
found a fix.

solution: create the queries manually. You can use the wizard to
build examples for reference, but both the crosstab and unmatched
queries are pretty quick to setup manually, and you wont be limited to
only include X number of row headings etc. that the wizard imposes.

just remember for the crosstab, you need exactly one Column Heading,
and exactly one Value. As many Row Headings as desired.


In the unmatched, in most cases, you do a Left Join from table 1 to
table 2 on primary key, then set primary key criteria on table 2 to Is
Null. this returns all records in table 1 NOT found in table 2.
 
Does this problem happen in just one database or all databases? If it happens
in just one database, create a new database file and import all the objects
from the problem database into it. See if that fixes things. If something
won't import, it's corrupt.
 
Jerry said:
Does this problem happen in just one database or all databases? If it happens
in just one database, create a new database file and import all the objects
from the problem database into it. See if that fixes things. If something
won't import, it's corrupt.
Click to expand...

Thanks Jerry and Ghetto for your response.

This problem happens on all the database on this system. The same files
work perfectly fine on other PCs.

For the unmatched queries, I do manage with manual queries with my skill
level. But I am not sure my current level allows me to create the
crosstab queries. Maybe I can give it a shot. Am not much of a
software person.

Still it would be useful to know why NONE of the fields are showing up
in the wizard screen. It is not just some of the fields.

Thanks for your inputs again.

Ramesh
 
I can't imagine this would be the problem but by any chance are all the
fields memo?
 
Duane said:
I can't imagine this would be the problem but by any chance are all the
fields memo?
Click to expand...

Duane, none of the fields are memo.

When the wizard gets to the screen where we select the fields for the
crosstab, (or unmatched fields) the field list is blank.

Problem happening only in this PC, with all databases.

Thanks
Ramesh
 
Ramesh said:
I use MSO2K. When i create a new crosstab query using the wizard, none of
the fields are getting listed in the tables. Similar problem I find with
Unmatched query wizard also. I have used both these wizards in the past on
the same system. Unable to recall anything which has been done on the
system which could have caused this problem.

I have to do a Detect and Repair operation. Problem still persists.

Any inputs on what could the problem be?

Thanks
Ramesh
Click to expand...
 
Back
Top