Updating Blank Records

  • Thread starter Thread starter HearSay
  • Start date Start date
H

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.
 
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?
 
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.
 
Back
Top