Only other thing that might trip you up is the format of the ProvService field. If it is text you'll probably have to put it in double quotes. i.e. "02" or "05".

Bit of a novice to this and, even worse, self-taught so could be missing something really obvious. Anyway, would very much appreciate help with:

Got a SQL table with a column that has NULLS in it. What I want to do is fill down the value in the row above based on a condition in another column (recordtype). Came up with the following code but unfortunately it only fills in the record directly below. Not those further down (variable...