P
pwu
Hi,
I am using Microsoft Access 2003.
I have table s1:
syd
mel
adl
per
bne
drw
s1 has only one field “server”
I have table s2:
syd
mel
s1 has only one field “server”
I run this query:
SELECT s1.server, spellboolean(s2.server) AS [Exists?]
FROM s1 LEFT JOIN s2 ON s1.server = s2.server;
The spellboolean function is as follows:
Function spellboolean(b As String) As String
spellboolean = " "
On Error GoTo spell_err
If IsNull(b) Then
spellboolean = " "
Else
spellboolean = "*"
End If
spell_err:
Exit Function
End Function
I get the following results:
server Exists?
syd *
mel *
adl #Error
per #Error
bne #Error
drw #Error
Can someone tell me why I get the “#Error” in the second column? How
can I fix this?
I have also tried testing:
if b=””
with the same results.
Thanks for any help.
I am using Microsoft Access 2003.
I have table s1:
syd
mel
adl
per
bne
drw
s1 has only one field “server”
I have table s2:
syd
mel
s1 has only one field “server”
I run this query:
SELECT s1.server, spellboolean(s2.server) AS [Exists?]
FROM s1 LEFT JOIN s2 ON s1.server = s2.server;
The spellboolean function is as follows:
Function spellboolean(b As String) As String
spellboolean = " "
On Error GoTo spell_err
If IsNull(b) Then
spellboolean = " "
Else
spellboolean = "*"
End If
spell_err:
Exit Function
End Function
I get the following results:
server Exists?
syd *
mel *
adl #Error
per #Error
bne #Error
drw #Error
Can someone tell me why I get the “#Error” in the second column? How
can I fix this?
I have also tried testing:
if b=””
with the same results.
Thanks for any help.