Query that Looks up values in another table

[atgordon]

I have 2 tables that have invoice number. In the query I am using to pull fields from one of the tables, I would like a column that checks to see if the invoice number present in table 1 is also in table 2 and if so, the word Yes is displayed in that row. If not, No is displayed in that row.

In essence, when run, the query would show all the info from Table 1 except for the column "invoice number check," in which case it would check if that invoice number is present in Table 2 and if so, it would display yes for that row.

I am not sure if I need to use a Select function in the calculated field or what.

Hopefully this makes some sense and is not too confusing.

 

[Norie]

You could perhaps use one of the aggregrate functions. eg DLookUp, DCount