Editing Table by looping through fields with different number

[zevw]

I am going through a description field in a table separated by spaces

I am using Split to capture each word in a separate field and the place it in the same table in field1, field2, field3 each time I loop around

How can I code the [BOLD] rst!field1 = splt [/BOLD] since the number 1 is placed in through a counter?

it does not recognize [BOLD] rst!Field & Cnt = splt [/BOLD]

    Do While rst.EOF = False
    Cnt = 1
    
        Wrd = Split(Nz(rst!Description, ""), " ")
        
            For Each splt In Wrd
                rst.Edit
                rst!Field & Cnt = splt
                Cnt = Cnt + 1
'                On Error Resume Next
                rst.Update
            Next
            
        rst.MoveNext
    
    Loop

 

[zevw]

I searched while waiting

and did this and it works!

rst.Fields("Field" & Cnt) = splt

 

[PHV]

Anyway, have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

What PHV’s hint is, I think, it is a VERY BAD IDEA to have a table with a structure like:
[tt]
Field1
Field2
Field3
Field4
...
[/tt]
And it is nightmare to program against.


Have fun.

---- Andy

 

[zevw]

This was all for a temp table and not a structural permanent table!

I also did not have a chance to read the article!

Thanks guys!