Look for most recent date in sub table

C

Chris

Sure.
Its the where clause that is tricky

You need something like ...

Where tblcontacts.primarykeyfield not in (select
Linkingtable.contactsPrimarykeyfield from Linkingtable
inner join tblNotes on linkingtable.notestableprimarykey =
tblnote.primarykeyfield where Notesdate > dateadd("m",-
6,now()))

it may pay to get the subquery - the bit in parenthesis -
working first before you use it in the where clause.
You should get a list of all contacts that HAVE a notes
record LESS than 6 month old. These will then be EXCLUDED
from the main query by the NOT IN part
 
Top