Recent content by 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.

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...

Thanks. Worked great!

I have a text field where the records are currently 1...next record 2, next record 3....up to 953. I am going to export this Access database to a dbf file. What I want is: That field to be 5 characters long. and right justified. so the first entry would be four space2 and then 1, four spaces...

That did it Looks like that worked too. Thanks!

I got it In the Update box I put [fieldname] + " CONVERSION" Seemed to do the trick.

I have a field that contains various text....(It's a note field that allows 86 characters). I want to go in to the database and add the string "Conversion 2007" to the end of every record. So leave whatever is in there but add in the string. I would like it to add whatever it will fit, in the...

Update Query Um...maybe I do. What I have is a generic field (from a Dbase III file) that contains multiple pieces of information. For example the 5th and 6th spot might be a state code and byte (character 134-142) might be a fax number number. If no fax number is given the it will be blank...

I think my question is easy...just not to me. I want to make a query that changes byte 75 in a certain field to a capital P. I also need to change byte 199 to N and 200 to S. Any help would be greatly appreciated.