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.

[vba]Function Null2Empty(strField) As String

If IsNull(strField) = True Then
Null2Empty = Empty
Else
Null2Empty = strField
End If

End Function[/vba]

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.