Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Using a form to create dynamic Query and chart

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
axwack - 13 Dec 2007 23:39 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.