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 - 15 Dec 2007 20:18 GMT
axwack,
Im going to guess, becuase I have never use this capability, but look at
Pivot Tables.
God Bless,
Mark A. Sam
>I was hoping someone could give me a steer to whether I should use
> Excel or Access...
[quoted text clipped - 10 lines]
>
> Any thoughts on the best way to implement this?