I’ve just spent a couple of hours on what should be a simple query and require some help.
What I am trying to do is calculate the pay of a person between two dates using an Access database and PHP.
Table name: Job
Field names: JOBPAY, STATUS, EMPLOYEEID, DATE
My current query looks like this...