I'm looking for a solution similar to filling in blank cells with the value above in Excel. But in my case if three fields in table "TypolLFSF" Other, Couple, Family are all 0, update the cells with the data of the first populated row above (each of the three fields can't be 0 but its acceptable if one or two of the fields are).
Is this is possible in access or excel? Please provide your advice and examples.
Below is my select statement.
SELECT TypolLFSF.*, TypolLFSF.Couple, TypolLFSF.Family, TypolLFSF.Other
WHERE (((TypolLFSF.Couple)=0) AND ((TypolLFSF.Family)=0) AND ((TypolLFSF.Other)=0));
I also need to set TypolLFSF.HCFMDCode to "C" when the value is updated.