| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
parameters not allowed
I found a thread in here regarding MSQuery limitation to create a parameter query when the query cannot be viewed graphically. i have inner and outer joins and a sub query in and need this to be a parameter query.
this was the advice given on that thread Create a VIEW on the database server containing the SQL. Modify your Excel app to query the VIEW rather than the base tables. I need to make several of these queries and the IT dept is hesitant to create views for them. Is there another way around this? Begrry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what does whitespace not allowed in this location mean and how do. | Excel Discussion (Misc queries) | |||
| Help : Using Parameters with External Date Query | Excel Discussion (Misc queries) | |||
| Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
| How to summarize data based on specific parameters | Excel Discussion (Misc queries) | |||
| Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
Linear Mode
