Microsoft Query
I've been skimming the book Excel 2010 Inside Out on the section for using MS Query. I was able to create a query based on excel data I have and it looks fine but I want to be able to have fields that I fill out and it automatically does a search. I don't want the user to have to deal with the MS Query interface. The book doesn't go into detail and was looking for another resource on Microsoft Query and wondered if anyone has any websites or books that go into more detail.
Thanks,
Chris
This may help you. I have not done parameter queries in MS Query, but have used Access for that. In Access you can set up a search form that allows the user to input the parameters which is very user friendly. You may want to consider using Access as a front end with forms for your users with Excel as your data source (backend).
http://office.microsoft.com/en-us/ex...005199548.aspx
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks