Omit ")" at the end of a sting (1 Viewer)

[mike wild]

have a ")" at the end of a string of text which i need to omit, any ideas?

i have this
IIf(Left([time],10)=")","",([time])))

but the whole thing deletes

 

[dcx693]

I answered your question here: Find and replace text in table

 

[AlanS]

Try this:

IIf(Right$([time], 1) = ")", Left$([time], Len([time]) - 1), [time])

Assuming that [time] refers to a field in a table or query, or to a text box on a form or report, it's good practice to not re-use system-defined names, which in some contexts may cause confusion - e.g., there is an intrinsic Access function named Time().

 

[mike wild]

Thank you works a treat