Brainfuddled Query

[Parker]

I have a table (call it table ‘A’)
Linked to another table ‘B’

I have a calculation query that runs on some other tables and produces calculated information on some 160 items.

I want to add a lookup field to table ‘B’ that pulls the calculated information from one item in the above query. But this information needs to use the value of the FK in the table as a select criteria. So, for each entry in the table the Query will be different.

I’m probably not looking at it right. It is Friday night and I was out driving @ 5am this morning so my brain is a bit more fried than normal.

Can someone help with the syntax please?

 

[Parker]

A query can be joined to a table or another query just as a table can be joined to a table. The only issue is a linking field. The query must have selected what ever linking field it needs to join to the table. Use the QBE grid to build the query.

Choose the table.
Choose the query.
Draw the join line.
Choose the columns you need from each.

Doh. Thanks Pat. I was trying to do it the hard way