Hi All:
I have a view containing numerous rows. One of the fields in my view is called ACCT. Some rows contain NULL value in the ACCT field. I need to know how to replace the NULL value with the previous row's value in the ACCT field in a reslut set of my view?

I.E
ACCT Order
---- -----
123 Shoes
876 Shirts
NULL Thread

I need to replace Null with 876.

Thanks for all of your help!!