Creating a button to make a PivotGraph

[dafinder]

Hello All,
I am having a bear of a time with access2003. I am trying to build a form with a button that creates a pivotgraph off of the data selected in the list boxes of the form. Is there a way to do this? Thank you so much.

James

[MMcCarthy]

Hello All,
I am having a bear of a time with access2003. I am trying to build a form with a button that creates a pivotgraph off of the data selected in the list boxes of the form. Is there a way to do this? Thank you so much.

James

You need to create a query based on the selections and then create the graph off the query.

[dafinder]

You need to create a query based on the selections and then create the graph off the query.

Thank you mmccarthy,

To reply to that, I am a complete novice when it comes to access2003. What would be the best way to structure this query? I currently have the list boxes displaying their values based off of 3 separate queries. When i try to create a query in the Wizard with the three fields i want from the form, Access gives me an error. Any help will be greatly appreciated. Thank you.

James

[MMcCarthy]

Thank you mmccarthy,

To reply to that, I am a complete novice when it comes to access2003. What would be the best way to structure this query? I currently have the list boxes displaying their values based off of 3 separate queries. When i try to create a query in the Wizard with the three fields i want from the form, Access gives me an error. Any help will be greatly appreciated. Thank you.

James

I would need to see the SQL of the query you are trying to create that is causing the error and I would need information on the listboxes you are using to set the criteria.