Enter Parameter Value in a Report 1

[rjr]

Why is it that when I run a query there is no problem, but when I run a report based on the query I get an Enter Parameter Value message? I have changed both the query and the report from time to time. Is there some consistency issue?

My query is as follows:

SELECT [sale-amn]/[acres] AS Expr2, [sale-amn]/[acres]/43560 AS Expr1, InternetSales.[sale-amn], InternetSales.acres, InternetSales.use, InternetSales.model, InternetSales.class, InternetSales.[land-val], InternetSales.[bldg-val], InternetSales.[xf-val], InternetSales.[tot-val], InternetSales.[sale-yr], InternetSales.[sale-mon], InternetSales.[sale-book], InternetSales.[sale-page], InternetSales.[sale-Inst], InternetSales.resvalcd, InternetSales.commvalcd, InternetSales.ayb, InternetSales.base, InternetSales.totsf, InternetSales.nbrbaths, InternetSales.nbrstories, InternetSales.zoning1, InternetSales.zoning2, InternetSales.zoning3, InternetSales.zoning4, InternetSales.zoning5, InternetSales.parcel, InternetSales.femacode, InternetSales.totcards
FROM InternetSales
WHERE ((([sale-amn]/[acres])<=50000) AND ((InternetSales.[sale-amn])>=15000 And (InternetSales.[sale-amn])<=150000) AND ((InternetSales.acres)>=2 And (InternetSales.acres)<=10) AND ((InternetSales.ayb)>=1999 Or (InternetSales.ayb)=0) AND ((InternetSales.zoning1) Like &quot;*ar*&quot; Or (InternetSales.zoning1) Like &quot;*ac*&quot AND ((InternetSales.parcel) Like &quot;182401*&quot; Or (InternetSales.parcel) Like &quot;182402*&quot; Or (InternetSales.parcel) Like &quot;182411*&quot; Or (InternetSales.parcel) Like &quot;182414*&quot; Or (InternetSales.parcel) Like &quot;182415*&quot; Or (InternetSales.parcel) Like &quot;182422*&quot; Or (InternetSales.parcel) Like &quot;182427*&quot; Or (InternetSales.parcel) Like &quot;182428*&quot; Or (InternetSales.parcel) Like &quot;182433*&quot; Or (InternetSales.parcel) Like &quot;182503*&quot; Or (InternetSales.parcel) Like &quot;182504*&quot; Or (InternetSales.parcel) Like &quot;182509*&quot; Or (InternetSales.parcel) Like &quot;182510*&quot)
ORDER BY [sale-amn]/[acres];


I get Enter Parameter Value for the fields [sale-yr] and [sale-mon] only, then the report displays normal.

Thanks for any help!!

 

[BattleDroid42]

The problem is in your report not the SQL. When prompted for values type in some garbage and see if/where it appears on the report. The should help you find the culprit.

 

[rjr]

Thought it might be the report, given the query showed no problems.

I typed in some text, i.e. &quot;TestYear&quot; and &quot;TestMonth&quot; in the respective fields ([sale-yr] and [sale-mon]). This text did not appear in the report. I removed the two fields from the report and placed them again from the Field List. I got the correct data corresponding to the table data, same as before. Any other ideas? Thanks for the help.

 

[BattleDroid42]

Okay, the next thing is to remove all instances of these two fields from the report and see if this still happens. Make sure to remove them from sorting and grouping on the view menu too. If it no longer occurs, add the fields gradually back into the report making sure this does not reoccur.

 

[rjr]

I see! I removed them from the Sorting and Grouping as well as the form, then replaced them and all is well. In the past I just removed them from the form. Man it pays to have the inside scoop!! Thanks much for your time.

 

[Mecha]

Hi

I am having a similar problem
I tried the removing all instances of my &quot;country&quot; field and then replacing them, but the same &quot;enter parameter value&quot; comes up

I am using a list box to enter the criteria.
When teh pop up comes up it has the name of the selected criteria on it, if i fill in the name again it will work, if i fill in other names, the other names will ocme up instead.

Would this issue always be cause by problems in the actual report and not the query?

Thanks

Carly

 

[rjr]

Did you remember to remove the fields from the Sorting and Grouping?