"NOT IN" Query in Access Web App (1 Viewer)

Good evening everyone,

I'm glad I finally found a good access support forum.
Currently I am working on an Access App for our sharepoint (office365).
To crosscheck entries and identify "Orphaned entries", I'd like to query any entry in table1 that is not reference in table2.

I wanted to use a macro in a view:

RequeryRecords
Where=[Table1].[UserID] NOT IN ([Table2].[RefUserID])

However that does not work. I have tried with queries, any kind of macro, lookups, but I'm not getting anywhere.

Does anyone have a suitable idea?

Thank you!
MABONETTI

Does the web app have the unmatched query wizard?

Well, although it does not have, your reply was very helpful, as it gave me some more ideas for googling.

Found that, which was very helpful:
https://www.experts-exchange.com/qu...Query-in-a-Microsoft-Access-2013-Web-App.html

Works like a charm.

MABONETTI

Glad you got it working, and welcome to the site by the way!