Dr.K
12-12-2007, 10:08 AM
My SQL skills are kinda weak... please be kind.
Currently, I use "null scrubber" function to Null fields into empty strings, becuase VBA will choke if its expecting a string and it gets a Null.
Function Null2Empty(strField) As String
If IsNull(strField) = True Then
Null2Empty = Empty
Else
Null2Empty = strField
End If
End Function
However, I pretty sure that there are ways of translating Nulls into Empty Strings right in the SQL statement, I just don't know how.
Any advice is apppreciated.
Currently, I use "null scrubber" function to Null fields into empty strings, becuase VBA will choke if its expecting a string and it gets a Null.
Function Null2Empty(strField) As String
If IsNull(strField) = True Then
Null2Empty = Empty
Else
Null2Empty = strField
End If
End Function
However, I pretty sure that there are ways of translating Nulls into Empty Strings right in the SQL statement, I just don't know how.
Any advice is apppreciated.