Syntax question

[PikPim]

Hi guys, I need to input this string as a parameter for the function dcount(it's in french but the important is the syntax):
str = "[Nom_service_affaire]='Taxe sur les primes d'assurance'"

The problem is that there are 3 " ' " and doesn't seem to like that it says that i got a missing argument or something like that... the problem is that i can'T remove the ' between "d" and "assurance"! It has to stay this way! :S anybody got an idea?

 

[Remou]

Make the d'assurance d''assurance. That is, double single quotes, or automatic:
Replace(strMatchString,"'","''")

 

[PikPim]

It doesn't work! all it does is put the rest of the code in commentaries (green) :S

 

[PHV]

And this (as already suggested) ?
[tt]str = "[Nom_service_affaire]='Taxe sur les primes d''assurance'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PikPim]

:O nvm it works now... sry