Previus value in table

[#1]

Hi

I got a table with three columns (Date, Code, Level).

Sometimes I getting null values in level column, when in level column is null I need replace to last value for specific code.

Example below:

Record 11/11/2011, K20 - is null the I need to get last value (sort by date) for K20 which is 150.

Please advise.

Thanks

[whiteline]

Please mark the answer as correct to close the thread.