I need some help and just can't seem to find the answers I am looking for.
I am running Access 2003 and need to create a pie chart based on a count of data in a table. However, I just can't quite get what I want after hours of trial and error.

I created the following 2 queries to count the records in my table:

SELECT DISTINCT StartAudit.ObserverName, StartAudit.StartDate,
StartAudit.EndDate
FROM StartAudit
GROUP BY StartAudit.ObserverName, StartAudit.StartDate,
StartAudit.EndDate
HAVING (((StartAudit.StartDate)=[Forms]![HoldingInfo]!
[TxtReportStart]) AND ((StartAudit.EndDate)=[Forms]![HoldingInfo]!
[TxtReportEnd]));



SELECT Count(*) AS [Audits Completed], 8-Count(*) AS [Not Completed]
FROM qryStartDistinct;

This will generate the following results:

[Audits Completed] [Not Completed]
6 ................................2

I need now to turn this data into a pie chart with a
query that will give results like:


Value1 ___________________Value2
Audits completed ____________6
Not Completed ______________2

Can anyone help me out, I am stumped :confused:. Thank you!