Need some help/advise on making pareto

[greenguy]

Hello All, This is my first post so after you read this you'll know what my knowledge level is (LOW). I have created an Access database and pretty comfortable with the data entry/update system. Now I'm moving on to creating the reports. I would love to have "drillable" charts and actually created some using pivot tables. I'm not sure I feel totally comfortable having the user drag fields and needing to understand Pivot Charts/Tables to view their data. I copied some code off the Microsoft office help (http://support.microsoft.com/kb/304143) but it's quite a bit above my head and am not sure how to make the chart look like what I need. So do I have other options for the drillable charts or is making pivot tables/charts my best option.

Thanks,
greenguy

 

[Premy]

I think the best is to create reports for every kind of info display u think the user might need, then create a navigation form from which the user just selects the view he is interested in.

HTH

Regards,
Jaime