HELP! Charts and Graphs With True or False Values

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

Guest

Hello,

I have a pie chart that is using 1 field (checkbox yes/no field) to show how
many are Yes and how many are No. Every time the legend displays it shows a
-1 or a 0. I edit the legend and in design view the report looks exactly like
i need it BUT when i switch to print preview it changes back to -1 and 0. How
do i get it to display the correct label?
 
You can modify the Row Source property of the chart control. If you can't
figure out how to do this, come back with the Row Source.
 
Duane,

I have the same issue and don't understand how I would go about changing the
rowsource to ensure the correct label appears in the chart. In my case, the
rowsource is:

SELECT Posts.Active, Count(Posts.Active) AS CountOfActive
FROM Posts
GROUP BY Posts.Active;

How would I modify the rowsource to have the label of the True/False
"Active" field be "Active" and "Inactive?"
 
Try:

SELECT IIf(Posts.Active,"Active", "Inactive") As Status, Count(Posts.Active)
AS CountOfActive
FROM Posts
GROUP BY IIf(Posts.Active,"Active", "Inactive");
 
Back
Top