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


G

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!!
 
Ad

Advertisements

G

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top