Help with a query

[Tronsliver]

I have a column in a table with many different text values. One of the values is "T0". What I want to do is go in and replace this value with just "0" for every occurence. I used this in the field window to try an accomplish.

BR_SCH_COMPL: IIf([sidstrBR_SCH_COMPL]="T0","0&quot

This worked fine but all other entries are now empty. That is I have a "0" for each "T0" but everything else is now gone. How can I keep the other data and still accomplish the task..

Thanks

Roger

 

[JoeMiller]

Change your code to this:

BR_SCH_COMPL: IIf([sidstrBR_SCH_COMPL]="T0","0",[sidstrBR_SCH_COMPL])


That should fix it.


Joe Miller
joe.miller@flotech.net

 

[Thanks]

Thank you..that is so obvious...duh