HELP! Charts and Graphs With True or False Values

[Adam]

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?

 

[Duane Hookom]

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.

 

[Pato-chan]

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?"

 

[Duane Hookom]

Try:

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