I have created a database for storing Incident reports. Each is identified by a unique Case Incident Number. To view reports, I built a query which asks for the Case Incident Number you wish to view in the report. This works fine from the query field.

However, when I run the report, which is looking through the query, it asks for the Case Incident Number, and then a second parameter prompt pops up. This is not asked for in the query, and the report is pointed at the query.. Any thoughts on where this second prompt snuck in? If you hit enter, it continues on its merry way and show you the report.

Any help is much appreciated

Peter Paul

Look for "Exp1:" as a prefix on one of the field names used in the query. This is can be caused by deleting, or renaming a field in a table. The query will convert this to an expression, giving you the problem you are getting. Just delete this field from your query and the problem should clear up.

Good Luck
RDH

[This message has been edited by R. Hicks (edited 03-04-2000).]

Are you running the query by itself and then running the report? If that is what you are doing - don't run the query by itself. When the report opens, the first thing it does is run the query. So in effect you are running the query twice and therefore being prompted twice.

Or, Rick might have given the answer.

Sometimes I've had the same problem, and found that I have a field name in the sorting/grouping area when the control field
is not on the report. Look there, and if
this is the case, just choose another control
field to group on, or delete it all together