H
Howard Brody
If your job numbers increase each time, try:
SELECT tblTable.Item, Max(tblTable.JobNumber) AS LastJob
FROM tblTable
GROUP BY tblTable.Item;
If your job numbers don't necessarily increase each time
then you will need another criteria to pull the LastJob
by. Maybe the job date.
Hope this helps!
Howard Brody
SELECT tblTable.Item, Max(tblTable.JobNumber) AS LastJob
FROM tblTable
GROUP BY tblTable.Item;
If your job numbers don't necessarily increase each time
then you will need another criteria to pull the LastJob
by. Maybe the job date.
Hope this helps!
Howard Brody