Copy field from one record to next in table

[Guest]

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?

 

[Joseph Meehan]

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?

Records in a table are not in any specific order. They are more like a
bucket of data.

Second it sounds like you need to look at your table design. If you
have a lot of repeated data from one record to another, it is likely you
need to normalize your table design so you have related tables.

It is not possible to give exact instructions without seeing the data,
but you likely will be able to do what you want by creating a query sorted
to provide the order and using it as an update query.

 

[Guest]

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?