Assigning the previous value in Access2K

[Raptor136]

Hi, I am trying to figure out how to assign a value to a table field once the text file import is complete.

Here's how the table 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

 

[Stipity]

Use a series of if statement to parse the values.

If col1 = Null then
/set value here
End if

 

[Raptor136]

I get the idea, I just don't know the language to tell it to set the value of the previous record.
Thanks

 

[Stipity]

Raptor,

I'm wondering if you've ever used DAO, ADO or SQL before. This is pretty simple db traversing. Probably better if you read up on it yourself first. Most vb sites have good tutorials on it

e.g.

http://www.vbexplorer.com/VBExplorer/databasetutorials.asp