#Error - possible Reference Library omission?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top