No , I dont have any control over the input
these additional fields are separated REPAIRWELDERS .
Will it cause a problem if each *REPAIRWELDER* has a separate record (not field but another record)?
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)
what did you mean of another record ?
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)?
no ......
in vb i'm novice
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.
you mean separating values in records ?
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.
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
The extra fields needed for the (...) values is finite and can then be completed from the single value REPAIR WELDERS value in each record.
you are right , but i can't do this
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?
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 ..