AboutScottGem Expertise I have been an IT professional for over 16 years. During that time I have accumulated a large store of knowledge and experience. This allows me to assist with a large variety of technology issues. My specialty is Database design primarily with MS Access. However, I can answer questions on many different IT related topics.
Experience I have worked in IT support for over 16 years. I have also helped people in cyberspace for a good portion of that time. I have been a volunteer staffer on Prodigy and AOL. I was the #2 ranked expert at AskMe.com (#1 in Technology) and am currently ranked at or near the top at Answerway.com and PointAsk.com.
Andrew Zima here - the one with all the MS Access bug-a-boos.
I did not know you were an Oracle Expert also. They have me working Oracle now - and as government usual - no training.
Mr. Zakrzewski:
In a discoverer report I want to replace the letter Y with the word REQUIRED.
I've tried the replace function with no luck. The syntax shows replace('char to be replaced', field to be search[,'replacement string']).
The report will rerun and nothing changes on the report.
Is replace the correct function or what is your suggestion.
Thank you,
A.D. Zima
Answer Hi Andrew,
Where did you get the idea I'm an Oracle expert? I'm not in any way. However, Oracle does use SQL. Is the 'Y' the only thing in the field? If it is, you you can use an IF in the query (or view) behind the report to replace it with a different word.
If you check the HELP for Oracle's SQL dialect, you can find the equivalent of IIF() function.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
