J
JCricket
If trying to figure out how to make a query that will look through an job
tracking log and return just the most recent record and the previous record
for a given job ID. For example, when a job ticket is created for a given
problem, it is given a job ID. Technicians will provide updates in the
database, and the time they enter their updates are logged. I just want to
make a query so that if I search for all the jobs worked on today, will
return both the most recent update and the update that was put in just before
that for each job.
tracking log and return just the most recent record and the previous record
for a given job ID. For example, when a job ticket is created for a given
problem, it is given a job ID. Technicians will provide updates in the
database, and the time they enter their updates are logged. I just want to
make a query so that if I search for all the jobs worked on today, will
return both the most recent update and the update that was put in just before
that for each job.