In crystal reports when I write a formula I can state a condition of say if the current field is blank, then print the content of the same field but from the previous record. The function is Previous () and it works beautifully. I need this same function in Access.
There has to be a way that I can do this in Microsoft Access. I am not a VBA developer but if someone points me in the right direction as to how to state this in an Access expression I think I can get it to work for me. I must say I am somewhat perturbed that it is not a straight forward out-of-the-box function in MS Access.