Cross tab / pie chart

Indigo

Registered User.
Local time
Today, 16:53
Joined
Nov 12, 2008
Messages
241
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:

Code:
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]));



Code:
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!
 

Users who are viewing this thread

Back
Top Bottom