×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Assigning the previous value in Access2K

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

Use a series of if statement to parse the values.

If col1 = Null then
      /set value here
End if

RE: Assigning the previous value in Access2K

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

RE: Assigning the previous value in Access2K

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources