Here is what I did.

I created a table with a Yes/No field, and populated it with sample data.

I then created a query that looks like this:

Query1:
SELECT Count(Table1.SampleID) AS CountOfSampleID, Table1.YesOrNo
FROM Table1
GROUP BY Table1.YesOrNo;

This grouped the Yes and No responses and gave me the following output in the query:

CountOfSampleID YesOrNo
5 Yes (checkbox)
3 No (checkbox)

I then created a report in Design View, and inserted a chart in the Detail Section:

Insert > Chart > Queries > Query1 > both fields > Pie Chart > Next > Name: Chart1

Then I open the report and the chart shows up as it should, with the legend -1, 0. This is because I didn't change the actual field to a Yes / No selection but kept the default -1/0.

What are you doing that is causing problems?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com