Hi,
So I'm trying to build a query here, and I know you can link fields in different tables to limit the results... but how do I link a field so that it is NOT in the list of results?
i.e. in TableA, there's a field "Requester name" with results a, b, c, d, ... x, y, z.
Then there's TableB, with a field "Name", that has b, d, z.
Can I link the two together, so that it excludes b, d and z, so my results will be a, c, e, f, g, ... w, x, y ?
If it helps, the query is like this at the moment, which doesn't help me. The query has the two fields joined, but will show me the results which IS in table B.
I hope I make sense... :D
Bookmarks