Replace Function Error
This is the syntax
Total: Replace([FirstOffer] & IIf(Len([Offer2])>0,", " & [Offer2],""),"|",",")
And it tells me undefined function 'Replace' in expression???
Competent Performer
Windows 7 64bit 
Access 2007
Replace Function Error
This is the syntax
Total: Replace([FirstOffer] & IIf(Len([Offer2])>0,", " & [Offer2],""),"|",",")
And it tells me undefined function 'Replace' in expression???
VIP
Windows XP Access 2010 32bit
Why Replace function?
Offer2 is text? Can Offer2 be null? Need to handle.
[FirstOffer] & IIf(IsNull([Offer2]),"","|" & [Offer2])
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Replace Function ? - how to replace the a 4th position null with a dash
Posting Permissions
Reply With Quote