parameter query 1

[Eyespi20]

I think I'm missing something somewhere. I'm trying to create a parameter query where a person will enter his/her id number and the query will pull only pertinent data to that id in the form of a pivot table.

When I follow the instructions on Microsoft's help and website, my query tells me that a parameter is not allowed.

It's a simple query from one table that's updated hourly by a stored procedure working at the database level, so all the query has to do is pull the information based on this one field that exists in the table.

What am I doing wrong?

Margaret

 

[SkipVought]

Hi,

Not sure why, exactly, but try doing the query WITHOUT the pivot table (Data/Get External Data...) Then pivot on the resultset.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[fneily]

Is this an Access question? Then it should be in the Access forums.
It would help to put the URL of the Microsoft reference so others can understand what you're talking about.
An access parameter prompt is placed on the criteria row of a query and is enclosed in square brackets [ ].
Please be more specific.

 

[Eyespi20]

This is in Excel.

The Microsoft web page I was referring to is

http://office.microsoft.com/en-us/assistance/HP051995481033.aspx

Thanks, Skip -- your suggestion works. Now to just get the query to prompt for that input everytime it's run.

Margaret

 

[SkipVought]

In Data/Get External Data/Parameters --

you can select from several options.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[Eyespi20]

Thanks, Skip -- works like a charm!

Margaret