Looks like you need a left join query on 3 tables (tables for users, stations, and station notes). Something like
Code:
SELECT u.LastName, u.ForeName, s.Station, sn.NoteDate, sn.Note
FROM tblUsers u
LEFT JOIN tblStationNotes sn ON sn.UserID = u.UserID
LEFT JOIN tblStations s ON s.StationID = sn.StationID
WHERE sn.NoteDate = Date()
This will return notes for all users - with Null notes field values when there were no notes for this user.
In case you need this query to return notes based on stations instead (a list of today's notes for all stations)
Code:
SELECT u.LastName, u.ForeName, s.Station, sn.NoteDate, sn.Note
FROM tblStations s
LEFT JOIN tblStationNotes sn ON sn.StationID = s.StationID
LEFT JOIN tblUsers u ON u.UserID = sn.UserID
WHERE sn.NoteDate = Date()