Display data that is in Table A and not in Table B

[cglass1015]

I am trying to generate a report that will display records in Table A that cannot not be found in Table B. The two tables are related to one another.

I am not sure what the best way to approach this report. Any suggestions would be greatly appreciated.

Thanks

 

[lbass]

Use a left join FROM tableA to tableB on a common field, e.g., {tableA.ID} ->{tableB.ID}. Then use a record selection formula like:

isnull({tableB.ID})

-LB