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.)
 
You must log in or register to reply here.

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 query for chart 8
Crosstab Query Chart 2
Cross tab query with averages? 4
Itereate cross tab query over another query 0
Cross tab query solution 4
Cross Tab Query to be used for calculations 1
Parameterizing in a Cross Tab Query 2
Cross Tab Line Numbers 3

Back
Top