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!