Using a form to create dynamic Query and chart

[axwack]

I was hoping someone could give me a steer to whether I should use
Excel or Access...

I have a SQL Server database that has data that I need to query from.
I am trying to build a query form, in excel or Access, that will allow
the user to choose certain criterial. This criteria is the basis for a
select statment and data to create a chart.

I am far more familiar with Excel's object model than Access...the
interesting thing is that Access has an ability to use a query as a
data source whereas excel has to select the data, put on a
spreadhsheet and then graph.

Any thoughts on the best way to implement this?

 

[Mark A. Sam]

axwack,

Im going to guess, becuase I have never use this capability, but look at
Pivot Tables.

God Bless,

Mark A. Sam