Page 3 of 5 FirstFirst 12345 LastLast
Results 31 to 45 of 62
  1. #31
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31

    Quote Originally Posted by RuralGuy View Post
    You are creating additional fields and *not* additional records. You would still need to split out the string into its separate fields. Do you have *any* control over the input?
    No , I dont have any control over the input
    these additional fields are separated REPAIRWELDERS .

  2. #32
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Will it cause a problem if each *REPAIRWELDER* has a separate record (not field but another record)?

  3. #33
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    i need the separated informations in fields , because i must calculate repair length of each welder , and type of defect (SL,LP,LOF,GM ,...) and type of welding (SMAW)
    FOR EXAMPLE :
    (15-SW-017[SMAW]#0~150,SL,RES#150~300,SL,RES)

    field1:15-SW-017 field2: SMAW field3: 300 field4:SL,GM field5:RES,RES

    "300 = (150-0)+(300-150)"

    all of these will be needed for repair percentage of each welder , for knowing which welder have high repair and must be rejected (expulsion)

  4. #34
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by RuralGuy View Post
    Will it cause a problem if each *REPAIRWELDER* has a separate record (not field but another record)?
    Did you understand this question?

  5. #35
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    what did you mean of another record ?

  6. #36
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    In your example db ID 607 would be broken into two separate records with only one REPAIR WELDER in each record. Do you understand the difference between a Field (column) and a record (row)?

  7. #37
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    no ......
    in vb i'm novice

  8. #38
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    In your sample db Sheet1 table the *record* with ID 607 has 2 values in the *REPAIR WELDERS* field where the *record* with ID 608 has no values in this field. I don't see how we can proceed without a better understanding of the difference between a field in a record and a record in a table. Records can have fields but fields cannot have records. Tables have records and those records have fields in them.

  9. #39
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    you mean separating values in records ?

  10. #40
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    When done, each record would only have one (...) value in the "REPAIR WELDERS" field. Once completed you would then proceed to break apart that (...) value into separate fields in that record for further processing.

  11. #41
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    1-What benefit doing this?
    2- i cant do this , because the table you see is not the complete table
    there is another fields that i count the value of them
    and calculate them

  12. #42
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The extra fields needed for the (...) values is finite and can then be completed from the single value REPAIR WELDERS value in each record.

  13. #43
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    you are right , but i can't do this

  14. #44
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Do you need any other field for what you are trying to accomplish? Can you just get by with a table that *only* has the REPAIR WELDERS field?

  15. #45
    evilleve is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Tehran
    Posts
    31
    yes for percentage calculation i need another field weldlength , about second question , i dont know , maybe , if the rows be same with other tables.
    i complete it more :
    http://rapidshare.com/files/451552031/Database3.accdb

    i seperate them to 3 fields , its not complete yet
    this way is so hard , and need many many fields.
    there must be a vba code for loading a table and using split function and creating new fields ..

Page 3 of 5 FirstFirst 12345 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Separate combo box
    By sanos_a in forum Access
    Replies: 1
    Last Post: 10-07-2010, 05:30 AM
  2. How To Chane Color Of Text In Columns
    By aamer in forum Access
    Replies: 5
    Last Post: 09-12-2010, 09:30 AM
  3. Run 2 Processes in Separate Threads
    By matt_tapia in forum Programming
    Replies: 1
    Last Post: 08-06-2009, 12:33 PM
  4. Separate queries?
    By sid in forum Queries
    Replies: 0
    Last Post: 08-01-2009, 10:31 AM
  5. Separate one field into many
    By ellen in forum Programming
    Replies: 5
    Last Post: 12-22-2008, 06:01 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums