#Error - possible Reference Library omission?

I'm comparing MyGroup with the few in RtrnNotice
to identify who (in MyGroup) still needs to "return Notice"
I've tried the below several ways but if there is a match I'm fine (VarType 8)
when there isn't a match (that's who I'm looking for) I get #Error

SELECT IIf([OrgNo]=[OrgID],"*",Null) AS Expr1, IIf(IsError([OrgID]),"","*")
AS Expr2, MyGroup.OrgNo, VarType([OrgID]) AS Expr3
FROM MyGroup LEFT JOIN RtrnNotice ON MyGroup.OrgNo = RtrnNotice.OrgID;

This is new location / new computer setup / I may be missing a DLL or
reference Library but which one???

I know you can select no matches I've done it before but on this system it
has issues evaluating that logic

--
Jim

If you did have a problem with library references, it could affect the query
since it does make function calles: IsError() and VarType().

The best approach might be to avoid those function calls. Instead use a
WHERE clause to ask for the record where the key field on the outer side of
the join is null.

There's an unmatched query wizard to do this if you wish. He's in the first
dialog when you start creating a query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"JASelep" wrote in message
...
I'm comparing MyGroup with the few in RtrnNotice
to identify who (in MyGroup) still needs to "return Notice"
I've tried the below several ways but if there is a match I'm fine
(VarType 8)
when there isn't a match (that's who I'm looking for) I get #Error

SELECT IIf([OrgNo]=[OrgID],"*",Null) AS Expr1,
IIf(IsError([OrgID]),"","*")
AS Expr2, MyGroup.OrgNo, VarType([OrgID]) AS Expr3
FROM MyGroup LEFT JOIN RtrnNotice ON MyGroup.OrgNo = RtrnNotice.OrgID;

This is new location / new computer setup / I may be missing a DLL or
reference Library but which one???

I know you can select no matches I've done it before but on this system it
has issues evaluating that logic

--
Jim