parameter prompt problem

[GBA]

Access 07

new report design; why am I getting a parameter prompt when opening report?

the field is not in the field list

the record source is a query that is a sum query of 2 fields from an
underlying query (will call this query 1)

I am being prompted for a value of a field in query 1 that isn't part the
sum query. query 1 doesn't have any parameter criterias.

no sorting or grouping or anything...this is a brand new query...

 

[GBA]

Allen Browne supplied fix in other dialog:

If the query runs without asking for these parameters, you've been caught by
the report optimizer. It tries to be too clever: if it doesn't see a control
bound to the field, it may not fetch it. But if the field is needed for an
expression somewhere, then it handles the unfetched field by popping up the
parameter box

 

[Gina Whipp]

GBA,

Sounds like there is a calculated field in Query1 that is not calculating
when you run the Sum Query. To verify and/or figure out what is going on
going to need a wee bit more information...

I would also check that you can open the query without opening the report to
confirm that it is in fact the query giving you the parameter prompt and not
some *bound to a lost field* in the report.

1. SQL of Query1
2. SQL of Sum Query
3. What is the wording of the Parameter Prompt you are getting?

To get the the SQL of the query go to the query grid and from the drop down
in the upper left hand corner select SQL. Copy/Paste that information here.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm