AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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.
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
__________________
Regards,
Laura
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
Pie Chart
Linear Mode
