Beginner Update Query

[Scootynm]

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.

 

[Malcy]

Please excuse if being thick but do you mean characters 75, 199 and 200?
If so you could use the InStr function quite nicely but would probably need to test first that the string is > 200 characters.

 

[Scootynm]

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.

Anyway, I know the structure sucks, but that's out of my control. What I need to do is put a "P" in the 75th spot.

Is this possible?