A
Amy Blankenship
I have a query that runs on top of a whole stack of other queries. When I
run the query inside Access, it only asks for the parameters (which are all
asked for by the lower-level queries) once. When I run it from outside
access, it asks for them twice. When I was creating the queries, I noticed
that if I pressed the a-z sort button in the query result set and then saved
the query, I would get the double prompts from within Access, but I am
fairly sure I didn't do that to these. Does anyone know how to reverse that
effect, in case that is the cause here?
Thanks;
Amy
run the query inside Access, it only asks for the parameters (which are all
asked for by the lower-level queries) once. When I run it from outside
access, it asks for them twice. When I was creating the queries, I noticed
that if I pressed the a-z sort button in the query result set and then saved
the query, I would get the double prompts from within Access, but I am
fairly sure I didn't do that to these. Does anyone know how to reverse that
effect, in case that is the cause here?
Thanks;
Amy