query creteria from another query

[Guest]

I am using the results of a query (sometimes a field in a table) as the
search creteria in another query. Sometimes I am successful and sometimes I
get the parameter query prompt. What am I inadvertently doing to get the
mixed results?

 

[Guest]

It would be very helpfull for other to see what you are doing to be able to
if some answers.

Post the SQL for both queries.

 

[David Cox]

When I get that problem it is usually because I have misspelt something or
have a unintended blank somewhere.