Is there a way to replace a null value with the value above? I have a data base that leaves some fields blank (all in one column). I need to copy the value that is above the blank fields into the blank fields.

I know this can be done in excel by selecting all the blank cells and using the formula =(arrow up), ctrl+enter, but my data base is too big for excel.

I'm new to access so any help is appreciated!

Hi,

I think you got the wrong forum!

This is for DSL Tools http://msdn.microsoft.com/vstudio/DSLTools/ (which you might be interested in of course...)

Try http://www.access-programmers.co.uk/forums/member.php?u=9114

Alan