Access Report Parameter Query

[Grey Whipple]

I have inherited a Report that includes a Parameter Query to input a value.

I want to change the 'user prompt'. The Parameter Query does not appear to be part of the underlying data query that supports the Report. And I do not find anything in the Report that sets up the Parameter Query.

Any help on where to look next?

 

[boblarson]

Double check on the query that it isn't a query on a query and the sub query may be where it's located.

 

[Grey Whipple]

Further snooping around has not yet revealed the existence of any sub-queries, but I have discovered another situation.

My Report references a Select Query. The Select Query works just fine and all the fields I want to use on the Report are present and all the data are present in the Query Datasheet View.

One of the Query fields I wish to use in the Report is STATUS, an alpha field. Now here is the rub. On the Report Design View, Access 2003 flags an error message stating that the STATUS field is not being passed to the Report.

And, in deed, looking at the Report Control Source, all the field names from the Query are there, except the STATUS field is missing.

How do I fix it. And I am wondering if this error is generating a default Report Parameter Query looking for the missing STATUS data.

 

[Grey Whipple]

Gadfry,
Now I'm looking at SQL code, and I have solved my problem!
I moved the Status variable, saved it, ran it, and voila!
GW