Update Query Question

[Scootynm]

I am working with a linked .dbf file. It has a field named GENERIC. Certain bytes in that field represent different things. The 5th byte through the 19th is the occupation of the person the record represents.

I know how to update that occupation from another table. Say its coming from OTHERTABLE.OCP

But how can I make it so the OTHERTABLE.OCP starts at the 5th byte of the GENERIC field.

So after I match up the keys which will tell me the records belong to the same person, I want to take the occupation from OTHERTABLE.OCP and write it to the SECONDTABLE.GENERIC field starting at the 5th byte.

Any help is greatly appreciated. Thanks.

 

[Scootynm]

Got It!

I used:

Left$([TABLE.GENERIC],4) & [NEWTABLE.OCP] & " " & MID([TABLE.GENERIC],20)

I used [NEWTABLE.OCP] (known to always be 7 characters and then 8 spaces to make sure all 15 bytes were used.

Probably not the best way, but I think it worked.