Thread: Access Pie Chart driving me crazy
View Single Post
  #7 (permalink)  
Old January 14th, 2009, 02:48 AM
Old Pedant Old Pedant is offline
Friend of Wrox
Points: 4,805, Level: 29
Points: 4,805, Level: 29 Points: 4,805, Level: 29 Points: 4,805, Level: 29
Activity: 38%
Activity: 38% Activity: 38% Activity: 38%
 
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,323
Thanks: 3
Thanked 70 Times in 69 Posts
Default
What do the labels say now???

I would *HOPE* that the chart is smart enough to pick up the names from your SQL query. Which means you SHOULD be able do do
Code:
SELECT Sum(Abs([Complete])) AS [Complete ], 
       Count(*) - Sum(Abs([Complete])) AS [Not Complete], 
       Count(*) AS [Total]
FROM tblDiscrepancies;
(Hope you didn't mind my simplifying your query slighly.) I put a space into [Complete ] so that the name would be the same as the name of a field. Sometimes the query engine chokes if you use a field name for an alias. It shouldn't, but it does.
Reply With Quote
The Following User Says Thank You to Old Pedant For This Useful Post:
kuznickic (January 15th, 2009)