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 עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks