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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

updatable query 13
criteria from another query 1
PARAMATER QUERY USING FIELD 8
too many merged records 5
too many records in merged piece 3
union query 4
duplicate vlues 9
Query running slow 5

Back
Top