Functions Not Working

[soloprogrammer]

I'm working remotely on an Access 2000 database application in a foreign country (Turkey). The backend is SQL Server.

Any new function I call from a query or form or report, no longer works. I keep getting the error "The expression you entered contains invalid syntax. You may have entered an operand without an operator." It doesn't seem to matter if it is a new function I've defined or an existing Access function--like SUM. Neither works. The existing functions on forms, queries, reports unmodified still work. Here's an example of an IIF statement I'm trying to set up in a form to avoid Divide By Zero Errors:
=iif([DryConstant]) = 0, 0, [Dry]/[DryConstant])

Any help would be appreciated.

 

[Hasu]

Hi,

You are missing one opening brecket "(" after IIF function.


iif(([DryConstant]) = 0, 0, [Dry]/[DryConstant])

OR

iif([DryConstant] = 0, 0, [Dry]/[DryConstant])



Hope this helps...
Hasu
(Trust on someone, someone will trust you!)

 

[soloprogrammer]

Thanks for the help--In my code the "(" was there. I discovered the problem-- you have to use semicolon ";" instead of comma "," when calling functions in Turkey. Ugh!