Deriving data from another query

[giladbr]

Hello everybody,
I'm an Access novice, so maybe my questions will be a bit foolish...
I have a query that says:
SELECT people.name
FROM people
WHERE people.ID=[TheID]![ID];

And I have a query called TheID which has a field named "ID".
But alas! When I run the first query, Access (2003 btw) prompts me for the value of the parameter "[TheID]![ID]".
How can I persuade Access that this is a query, not a parameter?

Thanks in advance!

Gilad

 

[pbaldy]

You need to add the query to the FROM clause. It would actually be more efficient to join the table to the query on that field rather than have the WHERE clause.