Can you replace a null value with the value above it, in mass?

[Guest]

I have a data base that downloads into access with some blank fields,
randomly. I need to copy the value above the blank (null) field and paste
that value down until I reach the next field that does have a value and
repeat that throughout the entire table. I know you can do this in excel by
choosing all blank fields and using the formula =(arrow up key) ctr+enter,
but my data base has too many lines for excel.

Any help is appreciated!!

 

[Guest]

You can "fill down" in Excel because a spreadsheet is an *ordered* set of
rows. Records in an Access table are unordered - there is no concept of
"previous" or "next" row UNLESS you specify an order based on some field of
the table. If you do, I'm not sure if an update query can do what you want,
but certainly VB code looping through a recordset can.

 

[Guest]

Thanks Ted!