Copy field from one record to next in table

A

Al Gilas

I import width delimited prn text file to my table. My prn file has empty
random fields only because it repeats from previous records. I would like to
put a formula in default value line in my table to add the contents from same
field in previous record when this record is null.

Any ideas?
 
T

Tom Wickerath

Hi Al,

Please see the following KB article:

How to fill record with data from previous record automatically in
Access 2000
http://support.microsoft.com/?id=210236

Note: This article applies to Access 2002 and 2003 as well.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I import width delimited prn text file to my table. My prn file has empty
random fields only because it repeats from previous records. I would like to
put a formula in default value line in my table to add the contents from same
field in previous record when this record is null.

Any ideas?
 
Top