Updating Blank Records

[HearSay]

I just imported a CSV into Access. No problems so far.

Problem is a lot of record have incomplete data. I would like to be able to
update the blank records with the value of the previous record.

As an example

Field 1 Field 2 Field 3

Record1 ABC DEF LKM
Record2 LKM
Record3 LKM

I need to update Record 2 and Record 3. The values that should be passed
are ABC and DEF respectively. There is no criteria needed to match records.

Can someone point me in the right direction.

 

[John Spencer]

Unless, you have some way to identify the preceding record this is not
possible. In other words, is there a field (or fields) that can be used to
impose the correct order.

If I gave you Row1, Row2 and Row3 on 3 pieces of paper (without labeling
them as Record1, Record2 and Record3) could you put them in the correct
order based only on the information in each record? If so, how?

 

[Guest]

There is no criteria needed to match records.<<
Ah, but there MUST be a criterion for matching records. Otherwise, how do we
know from which records to take the values to fill into the empty fields?
Access, being a relational database, has no inherent ordering of records,
hence there is no concept of preceding reocrd.