Crosstab Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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