|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2009, 02:42 PM
posted to microsoft.public.access.reports
|
|||
|
|||
parameter prompt problem
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... 
|
|
#2
August 6th, 2009, 04:07 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
parameter prompt problem
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 --------------- found an expression in the report's property in the OrderBy and also in the Filter...deleted those and the report opens fine.... "GBA" wrote: 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...
|
|
#3
August 6th, 2009, 04:13 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
parameter prompt problem
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 "GBA" wrote in message ... 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...
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
