Sounds like a Find Unmatched query. Access has a wizard for that.
VIP
Windows 10 
Access 2010 32bit
Sounds like a Find Unmatched query. Access has a wizard for that.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Very Inert Person
Windows 10 Access 2016
You can try the Unmatched query wizard, but even though I read your explanation at least twice, I'm not getting it completely. If that doesn't work I think you'll have to post some sample problem data and the desired results. Might be a good thing if you did that automatically from now on when posting such a question.
this Jobs and Assemblies is not the name of your table, surely??
if statement works in detail section of report, but not in the group header section
Replacing space in particular section of the field with Update query
Posting Permissions
Reply With Quote