Hello Phil,

Unforutunatley the data is sensitive so I cannot post it here.

I beleive I just need to add the following into the SELECT statement

(SELECT Max(id.[job #]) from instdat id where...