pie chart problem

[deltaair]

This maybe a little too elementary for this forum but i need help.

I have a table with the Fields
Date,
and then I have fields for various groups of delay codes, like Weather, Agent, bla bla,.....

1st I need to build a report with the total %age of each type of code for the dates in the data, and then a pie chart for those percentages for that entire time period in the table.

How should I go about doing this.

Thank you

 

[dhookom]

Have you considered normalizing your table structure so that delay codes are field values rather than field names?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[deltaair]

Well actually I thought that making them fields would work better, so the Table with the Fields is built using cross-tab queries from the original data which had the Delay codes as a value, so if i was to use the table with date and delay code, how would i build a calculated report with the %ages of each unique delay group in that, and then a pie chart from that.

I was thinking maybe a pivot table, but I can't figure out how to show %ages on the pivot table, or how to insert a pivot table in the report. and then the pie chart is another problem..

So what should I do now?
Thanks,

 

[dhookom]

There is a report with pie charts from a normalized survey application at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Select the Output Results button, Select the Sample survey, and click Statistics Summary w/Graphs. You will see several graphs where the QstnID is similar to your Date value and the Rspns is like your count of codes.



Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[deltaair]

Hello, thanks for your help with the report,

This report - Statistics with Summary, did you create from scratch in design view or is it created from a wizard. If so, how should I go about doing that. I know there is some issue with fields having to do with some being in header row or footer row or something

Also, another problem I have is that I have to show the top 7 of these delay groups only.

How can I solve that ?

Thanks

 

[dhookom]

I don't recall how I created the report. Probably trial and error until it worked. Keep in mind the Link Master Child is much like the same properties on subforms and subreports.

You might be able to set the chart control source to something like:
SELECT TOP 7...


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]