|I have two tables in Access and I want to find which of A has no B.|
TABLE MAIN, only field being used for query, ID.
TABLE ITEM, only field being uses for query, ITEM.
I am trying to find which ID entries have no, as in blank, ITEMs.
My query looks like this:
ID is linked to both tables.
What happens is I get nothing, as in no results, when I am using the query above.
Any help would be great, thank you.
Christian; warrior; GSPer; Borg; ninja; Time Lord... I am that hero! La resistenza è, ed è stato sempre, inutile.
I reply as fast as I can but could be hours or months.