Originally Posted by
Micron
In fact, I can't recall any built in function where the arguments are separated by semicolons. Are there any?
Depending on the OS regional settings. In my case (Greek), the separator of the arguments in expressions for form’s controls and for query design view, is the semicolon, but, not for the SQL and VBA code(!!!).
For example, this is an expression of a calculated field of a query in Expression builder:
Code:
Logo: IIf(IsNull([makeLogo]);Replace([makeName];" ";"_");[makeLogo])
and this is the same expression in SQL view:
Code:
IIf(IsNull([makeLogo]),Replace([makeName]," ","_"),[makeLogo]) AS Logo
As you see, is a pain in the ass, and, in the beginning, it is able to make you crazy.