Unanswered: string functions not working in sql statements
This only happens on machines using a runtime access engine
if I use a string function ie:
SELECT tblEmployee.Number, [FName] & " " & Left([lname],1) AS Name FROM tblEmployee
AS A RECORDSOURCE FOR A COMBO BOX
the box is null
I have seen this behavior only on some machines using the runtime version
Is there a dll that I may be missing or not registering in the install of our applications that may cause this - coincidentally these same machines bomb out when using the 'format" function as well in the sql statements.