Still having issues with this
Code:
SELECT PickfaceMaster.Pickface, PickfaceMaster.SelectPickface
FROM PickfaceMaster LEFT JOIN PickfaceCounts ON PickfaceMaster.[Pickface] = PickfaceCounts.[Location]
WHERE (((PickfaceCounts.Location) Is Null) AND ((PickfaceCounts.CountDate)>#8/1/2018#));
Basically,
PickfaceCounts table holds all the pickfaces that have been counted
PickfaceMaster table holds all the pickfaces that still need counting. (Over time this diminishes as the PickfacecCounts increases)
Once all the pickfaces have been counted I want the PickfaceMaster to show all the locations again which is why I need the date option.
I do hope that made sense : (