p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Pie Chart (http://p2p.wrox.com/showthread.php?t=12293)

lryckman April 26th, 2004 11:44 AM

Pie Chart
Good morning everyone,
I have a table with three different fields: EWR, Parts Order, and Misc. Then I have a bunch of other fields that stores the number of hours spent on the job. For each record, there will only be an EWR #, Parts order # or a misc job. (only one that applies to the job) I have a query that totals up the hours worked on that record in an expression.
I would like to total all on this into one pie chart showing the total numbers of hours spent on all EWRs, the total number of hours spent on Parts Orders, and the total number of hours spent on misc jobs in a months time. I know how to set the date restriction, but I can seem to get it to total all the expressions for each category and put it into a chart.
Any help on this would be greatly appreciated. I can e-mail the database if necessary.


The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

All times are GMT -4. The time now is 06:10 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.