Ok.
This database is old and I didn't know anything at the time, and I know there are problems in the naming conventions, save yourself some time and don't worry about explaining it
TableA = [Plan Table]
TableB = AnnualTrackingTable
Code:
SELECT [Plan Table].PlanNameID, [Plan Table].[Plan Year End], [Plan Table].TradingPartnerID, [Plan Table].StatFreqID, [Plan Table].[First Val Dates], [Plan Table].PlanStatusID, [Plan Table].[Term date], [Plan Table].PlanName, AnnualTrackingTable.PlanYearEndFROM [Plan Table] LEFT JOIN AnnualTrackingTable ON [Plan Table].[PlanNameID] = AnnualTrackingTable.[PlanNID]
WHERE ((([Plan Table].PlanStatusID)=1 Or ([Plan Table].PlanStatusID)=2) AND ((AnnualTrackingTable.PlanNID) Is Null))
ORDER BY [Plan Table].PlanName;
So the problem is that AnnualTrackingTable may have the record for 2014, however, not for 2015. How would I check based on "year-1"?