Pie charts / underlying query

O

Opal

I have been researching this all afternoon, and
I just can't seem to find the solution. I know
what I need but I just can't get from point A to
point B.

I am running access 2003. 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
(Point A)

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
(Point B)

How can I get to point B??? I have been trying
to create a crosstab but I don't have enough data
and I am stumped.
 

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 help 1
Complex Count Query 0
Unmatched query help 1
Left Join? 9
Changed query, Form went Blank 2
IIf help 1
SQL Query between 2 dates 5
Query Help 0

Top