Assigning the previous value in Access2K
Assigning the previous value in Access2K
(OP)
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





RE: Assigning the previous value in Access2K
If col1 = Null then
/set value here
End if
RE: Assigning the previous value in Access2K
Thanks
RE: Assigning the previous value in Access2K
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