Report Asks for Criteria Twice

[CCIDBMNG]

I have a report based on a crosstab query which has an input box for criteria. When I run the query it asks for the criteria once but when I run the report it asks for it twice. It even asks for the criteria when the report is closing. Does anyone know why it does this or how to stop it?

Thanks ahead

 

[kavarin]

I wish I could say I knew for sure, but this happened to me as well. For myself, I found that the report I ran was based on a query. That query had a field that I chose not to show, but specified a criteria for. As soon as I enabled the show function, the double prompt stopped.
For what it's worth--

 

[CCIDBMNG]

was it a select query or a crosstab query. I tried doing what you said in my crosstab query and it still does it.

 

[CCIDBMNG]

Someone please help.....I've tried moving the criteria to the the union query I have that the crosstab query is based on and the report still asks for the criteria twice.

 

[kavarin]

Mine was a firly simple SELCT query with alot of fields included. Sorry I couldnt be more helpful. Im just learning this stuff

 

[CCIDBMNG]

Pat can I do it with a report field or does it have to be a form field?

 

[CCIDBMNG]

Thank you soooo much Pat, I just created a simple form with two text boxes for the criteria and a button to run the report there and it worked great. I've been pulling my hair out for two days now. Thanks again.