Report or Query to use?

[shadowsedge]

I have not used access since 2003 version. I am relearning Access on Window 10 with Access 2016. (2013 version I believe?)



I want to query my database I created to see if someone has completed their part.

On table 1, people enter problems.
On table 2, managers enter solutions.

There are 2 tables so that managers can only see their specific records and people can only see their specific records.

I created a report that shows completed records but not uncompleted. How do I show the uncompleted so I can send out notifications?

Thx in advance.

[ranman256]

if there is no matching solution record, you need to make an outer join the the tSolutions table.
set show all records in tProblems, and SOME records in tSolutions
show tProblem.name joined to tSolution.name, (or wherever you join them)
and add NULL as criteria to tSolution.name

this will show whats missing

[shadowsedge]

Well butter my bread! That worked. Thx!