Using Parameters in an external data query

B

Bdavis

For some reason, whenever I do an external data query, the Parameters
button/feture is ghosted and unavailable. Can someone explain why this might
be happening?
 
D

Don Guillett

You need to set focus on the query area by putting your cursor on the cells
where the query is.
 
D

Darren

It really depends on the type of query, usually only the most basic queries
can be supported by parameters.
If your query is derived from views, or if youve got some complex
(relitively) case statements most of MSquery's GUI functions switch off.

This is a really anaoying problem, many times I am asked to change a report
because the user wants to see a different date range, or something like
that, so I have to physically change the original report and then you get
version control issues, whereas if the parameter function worked properly,
the user could make the changes.
 
B

Bdavis

Let me be more specific:

1) I use Data>Import External Date>New Database Query

2) I then brows to an Access data base, select the table and fields I want,
complete the wizard and return the data to a sheet in Excel.

3) The data is correct and updates correctly but the parameter button is
ghosted. I realize you have to have a cell selected within the data range
and and I do.

Any ideas?
 
Top