Format

[mayu03]

I have the following statement in my module.
For some reason (I can't understand...) it is running on one pc but not running on the other.
I am getting an error about format function. Can you help me please....
qdf.SQL = "SELECT CVSSN, CVGRP, CVLOC, Format(CVLECY, '00') & Format(CVLEYR, '00') & Format(CVLEMT, '00') & Format(CVLEDY, '00') AS EFF, ...

 

[SteveR77]

Try using double quotes instead of single quotes.

HTH,

Steve

 

[GoDawgs]

Sounds like you're missing a dll file on the computer with the error...check the references (tools->references in a code window) and see if anything says "missing" next to it.

Hope that helps.

Kevin

 

[mayu03]

I can't chaneg to the double qu. it gives me an error

 

[mayu03]

I try to look at reference to see if any dll missing and I couldn't see anything missing. To what libraty belong format?

 

[GoDawgs]

What error exactly are you getting?