Automatic field generation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TechieRob - 11 Apr 2005 06:56 GMT

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.

Reply to this Message

Jeff Boyce - 11 Apr 2005 11:47 GMT

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.

Signature

Good luck

Jeff Boyce
<Access MVP>

> 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
[quoted text clipped - 14 lines]
> Basically all i want is a simple "Next field"=="previous field" for all
> fields in the date column.

Reply to this Message