Fill Null Fields with Previous Field

[radmad]

I have imported a csv report into a table. The report does not fill down each heading for each record. Using a query, I can check each field for a null value and replace with another value. But I would like to automate it to fill each null field with the first value in the field.

Before Example:

STYLE COLOR SIZE BACKING
N1718 9295 21024C BK
LC
LI
LI
Required Example:

STYLE COLOR SIZE BACKING
N1718 9295 21024C BK
N1718 9295 21024C LC
N1718 9295 21024C LI
N1718 9295 21024C LI

 

[dhookom]

Do you have a primary key in the table that establishes things like "first" and "fill down"?

Records are like school children on a playground. There is no order.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]