input query prompting twice

[Access Newbie]

I have a query set up that prompts you to enter a date. The problem that I
am having is that when the query is ran, it is prompting for the same
informaton twice before it will run the query. Do anyone know how to avoid
this or what I may have done wrong for it to do this?

Thanks!

 

[Ken Snell \(MVP\)]

Usual cause for this is that you have not "spelled" the parameter texts
exactly the same in all places in the query where you're using it.

For example:

SELECT * FROM TableName
WHERE FieldName1 < [Enter ID:]
AND FieldName2 > [Enter ID];

The above will cause two parameter boxes to be shown because the two
parameter texts are not the same.