MS Access Query Criteria help - Microsoft Community
have msaccess table ("combined") and created query makes sure 2 fields (in same table) have data in them ("ftnb"). need create separate query (to used in mail merge) looks @ combined , subtracts out matching records ftnb. help!
you can use left or right join in query , set criteria of null under 1 of fields non-matching.
without exact table , field names common field(s) it's bit difficult provide non-generic answer. might work:
select tablea.*
from tableb right join tablea on tableb.fielda = tablea.fielda
where tableb.fielda null;
Office / Access / Windows 10 / Office 2016
Comments
Post a Comment