Automatic field generation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a flat text file with some information missing in Access 2000
The data is stored in a table where there are blank entries for "dates" but
the date is the same as the leading date:

i.e.

Date Name Job
01/01/01 Jack Install system
Joe Configure software
Bob Printer Jam
02/01/01 Fred Fix Mouse

the missing dates in this table is obviously 01/01/01. My question is; can
you write a expression that will automatically fill in a field based on its
previous record's entry?

Basically all i want is a simple "Next field"=="previous field" for all
fields in the date column.
 
One approach would be to write a procedure that loops through the records,
preserving the record's date, and using the preserved date unless the record
has a new (i.e., different) date.

In statistics, having no information doesn't mean interpolation (filling in
between) is valid -- sometimes no date means no date.
 
Back
Top