Parameter Query
You query may not be returning any data becasue there is no data that matches
all 4 filters.
I usually debug my queries using the query editor. The editor will show you
the data that matches the filters in real time and give you errors if your
sql has errors.
From excel 2003
Select a cell wherre data is returned using 3 filters
then from worksheet menu
Data - Import External Data - Edit query
Look for the SQL box and select. Modify the SQL as required and you will
see the items returned from the query. Change the SQL until you understand
the problem.
"Lee" wrote:
I seem to be hitting a limit in the number of parameters Excel takes in
getting data. The query in MS Query does return records alright with four
parameters, but it will not return the data to the worksheet. It does fine
with only three parameters. The parameters are set to read specific cells in
the workbook.
I have modified the query by alternately hardcoding the parameters to see if
any one of them was the problem and the query returns data just fine....so
long as there are only three parameters. Any ideas?
|