How to assign preceeding value to a null field

[Raptor136]

Hi, I am trying to figure out how to assign a value to a field from a text report.

Here's how it looks once the import is complete.

ERO_No Job_Status Job_date
XP001 INSHOP 8/1/02
BACKORDER 7/1/02
RECVD SHOP 6/30/02

XP002 RECVD SHOP 8/1/02
XP003 INSHOP 8/1/02
RECVD SHOP 7/29/02

I want it to look like this:
ERO_No Job_Status Job_date
XP001 INSHOP 8/1/02
XP001 BACKORDER 7/1/02
XP001 RECVD SHOP 6/30/02
XP002 RECVD SHOP 8/1/02
XP003 INSHOP 8/1/02
XP003 RECVD SHOP 7/29/02

What happens is that every status is now corresponding with the appropriate ERO_No, and the blank line goes away.

All help appreciated. TIA raptor136@adelphia.net

 

[SBendBuckeye]

How are you processing your text file? Are you spinning through a recordset, sending it to a form one record at a time, etc? If you can provide some more information it will be easier to help.

Good Luck! Please remember to give helpful posts the stars they deserve! This makes the post more visible to others in need!