query creteria from another query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
When I get that problem it is usually because I have misspelt something or
have a unintended blank somewhere.
 
Back
Top