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:
This will generate the following results:
[Audits Completed] [Not Completed]
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
. Thank you!
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
