I created a view several years ago that has been working well. Basically it selects a value from a row directly below it. Now, I would like to add another column to the view but when I try to save it, I get the error message 'Incorrect Syntax near ')'. If I try to run just the query, it indicates a problem with the ')' in line 3 (circled in red below). The field I am trying to add is 'RUN_TYPE' (highlighted in yellow). Can anyone see what I might be doing wrong? Thank you, in advance, for your help.