I am developing a page that needs to log calls from soldiers signing on and off at remote locations. I have two tables:
tblLoneWorking - lists all the calls that we should have, with the fields Location, Time and Type
tblLoneWorkingCalls - lists all the calls we have received, with the fields timeStamp, Location and Type.
I want to retrieve all the records from tblLoneWorking where there is not a corresponding record of the same location and type for today AND the time is earlier than now.
I didn't find the right solution from the Internet.