Query from 2 tables

[Guest]

I'm not sure if I'm suppose to run a query for this question but hopefully
someone can help me.

I have two tables with invoice numbers. From these tables I want it to tell
me if it's listed on each table.

For example :
Table 1: invoice # 11

Table 2: invoice # 11

It's appearing on both. " Yes ", if not, " No "

HELP

 

[John Vinson]

I'm not sure if I'm suppose to run a query for this question but hopefully
someone can help me.

I have two tables with invoice numbers. From these tables I want it to tell
me if it's listed on each table.

For example :
Table 1: invoice # 11

Table 2: invoice # 11

It's appearing on both. " Yes ", if not, " No "

HELP

Create a Query. Add both tables. Join them by Invoice Number. Display
whatever fields you want - you'll see only those records which appear
in both tables.

If you want to see all the records in Table1 and a Yes or No if there
is a match in Table2, select the join line in the query grid and
choose option 2: "Show all records in Table1..." Select the invoice
number (and if desired) other fields from Table1; in a vacant Field
cell type

InTable2: IIF(IsNull([Table2].[InvoiceNo], "No", "Yes")

John W. Vinson[MVP]