Display record from one table not found in other table

Jet Reports Historic Posts

July 28, 2009 17:05

None

Hi

I am writing a query where there are two tables with field "A". Based on that field I need to write a query where I need to display all the records for "A" which is not found in table "B".

Please help

Date Votes

1 comment

0

Jet Reports Historic Posts July 29, 2009 01:39

I Personally haven't tried this…but try "<>"&NL("Filter",)
with the Filter criteria you don't want.

Or experiment with NL("Rows",NP("Difference",NL(Table A),NL(Table B)))

Comment actions Permalink

Please sign in to leave a comment.