query creteria from another query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sierralightfoot - 13 Aug 2006 18:37 GMT

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?

Reply to this Message

KARL DEWEY - 14 Aug 2006 04:00 GMT

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.

> 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?

Reply to this Message

David Cox - 14 Aug 2006 12:11 GMT

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

>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?

Reply to this Message