Using a form to create dynamic Query and chart

  • Thread starter Thread starter axwack
  • Start date Start date
A

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?
 
axwack,

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

God Bless,

Mark A. Sam
 
Back
Top