I am building a database that will tie together the labor and material that are used on projects. I would like to have a report that displays among other things the following:
Estimated Hours
Hours Used
So as the project goes along the "Hours Used" would steadily increase, while the "Estimated Hours" is set when the project is undertaken. I want to have a Pie Chart on the report that would indicate the percentage of Hours Used against what was estimated. I quickly saw that to do this I would need another field "Hours Remaining" which is basically just "Estimated Hours" - "Hours Used".
I have all of these fields in a quary, however I don't seem to be able to dictate how a pie chart recieves its data. Because the quary is designed to only return one record for the report, I'm looking at this:
Project ID : Q837
Estimated Hours: 520
Hours Used: 320
Hours Remaining: 200
The way the chart seems to be looking at the information is that I assign which field I want the data to be used from. Let's suppose that I use Hours Used. It appears to be looking for a column of information, however since it only sees one record containing 320, I end up with a blank pie chart. What I'm trying to accomplish is for the chart to graph the Hours Used and Hours Remaining fields.
Initially, I figured this would be an simple chart wizard adjustment. However, in searching around I see this problem has been asked in a number of different forums, so I don't feel too bad. The ones that seem to end up having an answer post "I figured it out" but don't explain how.
Any help would be appreciated.
Estimated Hours
Hours Used
So as the project goes along the "Hours Used" would steadily increase, while the "Estimated Hours" is set when the project is undertaken. I want to have a Pie Chart on the report that would indicate the percentage of Hours Used against what was estimated. I quickly saw that to do this I would need another field "Hours Remaining" which is basically just "Estimated Hours" - "Hours Used".
I have all of these fields in a quary, however I don't seem to be able to dictate how a pie chart recieves its data. Because the quary is designed to only return one record for the report, I'm looking at this:
Project ID : Q837
Estimated Hours: 520
Hours Used: 320
Hours Remaining: 200
The way the chart seems to be looking at the information is that I assign which field I want the data to be used from. Let's suppose that I use Hours Used. It appears to be looking for a column of information, however since it only sees one record containing 320, I end up with a blank pie chart. What I'm trying to accomplish is for the chart to graph the Hours Used and Hours Remaining fields.
Initially, I figured this would be an simple chart wizard adjustment. However, in searching around I see this problem has been asked in a number of different forums, so I don't feel too bad. The ones that seem to end up having an answer post "I figured it out" but don't explain how.
Any help would be appreciated.
