Cross tab query for chart

  • Thread starter Thread starter Zegrath
  • Start date Start date
Z

Zegrath

I have a table with the fields
[Year]
[StationName]
[ReactorState]
[InternalDose]
[ExternalDose]

ReactorState has 12 options: 4 of which are At power and 4
of which are shutdown. IE: At Power - Inservice Inspection.
The others include Post LOCA, Decommisioned, Not
Applicable and Unknown.

I need to make a crosstab query for a chart source that
plots stacked bars. The bars need to show internal dose
divided into at power and shutdown at the bottom and
external dose divided by state stacked above that. The
problem is that I need all the At Power and Shutdown types
grouped into 2 instead of 8 with the other names left
alone. I cant use an iif() statement in the query because
that only allows for 2 groups. Any suggestions?
 
I like to make a fake 'table' in Excel, and practice making the chart there.
Once I get the chart to look like what I want, I work towards manipulating
the data in the table to look like the data in the Excel file.(Via queries,
mostly.)
 
Back
Top