MAKE TABLE QUERY ASKING "ENTER PARAMETER VALUE"

[slapupp]

I have a make table query in Access which, when running, prompts me to "enter parameter value" for a calculated field in the query. It then propmts me again for a parameter value for another calculated field which uses the first calculated field in its calculation. By hitting ok (and entering no parameter value at all) through both prompts, the make table produced the desired results. Is there any way to get around these prompts, since it is causing the macro I have set up to run a group of queries to halt at this point.

Thank you,

Mike

 

[Aivars]

Check carefully step by step criterias and fields of query. It would happen when you was changed form controls or table design which associate in your query.

Aivars

 

[StewartGW]

Had this problem the other day. To avoid this, substitute the parameter value for the calculated field with the actual. The second prompt should then disappear.