Here is an easy solution, it works just like in Access
Public Function Nz(Value1 As Variant, ifNull As Variant)
If Value1 = "" Then
Nz = ifNull
else
Nz = Value1
End If
End Function
Hi! I am Brad, from Antigua And Barbuda. I am a network technician and db developer. I am pretty decent VBA programmer, I was looking at a thread for an answer and didn't find it so I developed it and want to post the solution.