Hey guys:
This is a problem that I run into intermittently in Access. I run office XP.
I write a query that works fine when it is first run. Then when I try to run it again, it asks me to enter a parameter value for one of the fields when it actually is not a parameter query. I dont know why this keeps happening but it happens.
It usually happens in queries that I use aggregate functions. The only way it works is if I delete the query and re-write it. Then it works once or twice and then it stops working again.
Did anyone else have similar issues? What could be the problem?
Thanks.
This is a problem that I run into intermittently in Access. I run office XP.
I write a query that works fine when it is first run. Then when I try to run it again, it asks me to enter a parameter value for one of the fields when it actually is not a parameter query. I dont know why this keeps happening but it happens.
It usually happens in queries that I use aggregate functions. The only way it works is if I delete the query and re-write it. Then it works once or twice and then it stops working again.
Did anyone else have similar issues? What could be the problem?
Thanks.