Manipulation

[Jammin]

I have a form with that displays a whole bunch of records. The control source is a query of three different tables. I need to somewhere along the process, take part of the info in a field and then add a set parameter to it. For instance, I have R851B20L. I need to take out 20L and then change it to J20L. I have successfully been able to seperate the information, now I need to know how to add to it, whether it be in the form or in the query, or in the table.
I thank you greatly.

Jammin

 

[Deb in LA]

If you can separate it, you can put it back...

lets say that field1 changed with this: left([field1],5)
That will give you field1 without the bad ending.
Try left([field1],5)&"J20L" in your append query - try displaying it first -- it should take the 2 parts and put them together correctly. Then append this.
Hope this helps.
Deb

 

[Jammin]

Thanks, all I needed was the "J" & to add to my parsed text. Almost sounds too simple. I appreciate the information.

Jammin