Expression not valid - Query

[char]

Hi everyone!


I have two tables, [ATWelding] and [Results] . They are linked as they both have Weld ID.
I want query to show any ATWeld ID that doesnt match a Weld ID in [Results].

I can't use SQL as my database is on the web compatible platform.
I attempted to do this using InStr([Results]![Weld ID]) in my Weld ID ATWelding criteria on a query but as I am using the web version an error message saying the expression is not compatible with the web is being displayed.

Can anyone help me find away around this problem so that I can run the query in my web database? Any suggestions would be greatly appreciated!

[June7]

A query IS sql. Did you mean you can't use VBA?

Build a query that joins the two tables, jointype 'Include all records from ATWelding...'. Criteria under Results!WeldID: Is Null

[char]

Ah thank you. Joined the tables and then ran the query, worked perfectly.