max value criteria

[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