Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel DB Query Parameter for all values
I my excel file connecting to access via Microsoft Query which is
pulling a table. I have set a filter on a field to get only the item results I need (one of about 30) and my excel file builds a pretty report from the data. It works well. Now I need to be able to return all of the values but I cannot pass a null filter to my query to return all of the records. I have a drop down in my excel file that the user can select the filter they want. Right now I have only one item. I want them to be able to select "All" and the query returns all records. Also, I'm hoping there is a way to do this without needing to redo everything in VBA. My SQL Statement from MS Query: SELECT tbl_Output_Results.LOB, tbl_Output_Results.SUMMARY_LINE_FLASH, tbl_Output_Results.ACCOUNT, tbl_Output_Results.SUMMARY_ACCOUNT_NAME, tbl_Output_Results.DESCRIPTION, tbl_Output_Results.`Jan08 Act`, tbl_Output_Results.`Feb08 Act`, tbl_Output_Results.`Mar08 Act`, tbl_Output_Results.`Apr08 Act`, tbl_Output_Results.`May08 Act`, tbl_Output_Results.`Jun08 Act`, tbl_Output_Results.`Jan08 Plan`, tbl_Output_Results.`Feb08 Plan`, tbl_Output_Results.`Mar08 Plan`, tbl_Output_Results.`Apr08 Plan`, tbl_Output_Results.`May08 Plan`, tbl_Output_Results.`Jun08 Plan` FROM tbl_Output_Results tbl_Output_Results WHERE (tbl_Output_Results.LOB=?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter query in MS Query from Excel | Excel Discussion (Misc queries) | |||
Parameter Query to return multiple values | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
How to put a parameter into an Excel Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |