Crosstab Report?

[Guest]

I have the following table that is compiled from (hundreds of) spreadhsheets.
--- DEPTID, DATE, EMPNAME, CGI, RATING, WEIGHT.

CGI contains a description of a skill. This field had to be imported like
this because it is variable - it changes from 1 sheet to the next (I think
there is a max of 7 in one section and 14 in another for an overall total of
21)...this is important because...

....I'm trying to create a report with the CGI field as a column header.
Other than a Pivot Table view (form), is there any other way to do this?
I've also tried a CrossTab query - which is fine, except I need headers and
formatting, etc. This won't work because, again, the CGI is variable.

Any suggestions are much appreciated.

 

[Guest]

Oops - saw all of the posts after I wrote mine. But Duane Hookom's is a bit
more complex than what I was looking for - Duane, hopefully there's something
simpler?

 

[Guest]

I agree the solution isn't simple. I generally need to look over the code
when creating a crosstab report. I think there is a table in the MDB with a
detailed description. Other solutions that I have seen are more complex, use
more code, run slower, and are less flexible.

Once you get your head around the basic concept, it isn't too difficult.

 

[Guest]

You might try this, see if you can build a table one way or another using a
make-table query of all the CGI Values. You mentioned you had hundreds of
tables but I assume if you want a column header using the CGI there are not
100s of values for it. Once you have a table of unique CGI Values, by using
a join on that field, you can get your crosstab to use that field as a
variable column

 

[Guest]

Duane,
I've come to the conclusion that what I was asked for is not really possible
(in the time available) in 1 report (crosstab or otherwise). I talked them
into using the Pivot Table form/report and showed them just how easy it is to
filter for what they need...musch easier than any static report I would need
to create. The fact that a Pivot Chart can also be created was definitely a
deal maker.

I re-counted the number of fields and it looks like a total of 30 is closer
to the actual number of those variable fields. If I recreate the crosstab
report and just take my time (yeah, right) and create those 30 headers and
fields (manually!), I can get what was requested. But that's further down
the road.

Long live the Pivot Table! ;o)

Thanks for your assistance yet again.