Query to show missing records (1 Viewer)

[cbroshar]

I have a database with tblStudents and tblIncome.

tblStudents includes fields StDisplay (student name) and Status (either "Active" or "Inactive"). tblIncome includes fields TaxYear (either 2021 or 2022) and AGIncome (adjusted gross income for that particular year for each student).

I would like a query to return StDisplay (if Status is "Active") and Income for TaxYear 2022 - but also include StDisplay if there is no record for TaxYear 2022. In other words, I am trying to identify which active students I forgot to enter 2022 income for, while also displaying 2022 income for all active students.

Help!

 

[MajP]

MS Access - Joins

MS Access - Joins - A database is a collection of tables of data that allow logical relationships to each other. You use relationships to connect tables by fields that they have in common. A table can be part of any number of relationships, but each relationship always has exactly two tables. In...

www.tutorialspoint.com

left outer join.