replace problem

[Marcel2586]

Hello all,

I have a table and in this table i have a field called MainWrkctr.
The records shows 1000/2600, 1000/2400CK, 1000/1600 and so on.
What i need is only behind 1000/.
I tried a update query Replace([MainWrkctr],"1000/","")
Also MID ([MainWrkctr],5,4) and Right([MainWrkctr],4)
But all seems to fail, i still get 1000/2600


Thanks in advance

 

[MStef]

I suggest to use an UPDATE QUERY.
Look at "DemoReplace1000A2000.mdb" (attachment, zip).
Look at Table1, Query1.
Run Query1, before make a copy of your table.

 

[NickHa]

Another method is

SELECT Right(MainWrkctr, Len(MainWrkctr) - InStr(1, MainWrkctr, "/")) AS ShortWrkctr FROM tt;

 

[Marcel2586]

And again thank you for your help NickHa.