I am pretty new to Access and am having trouble with a join query that I am trying to create. I have 3 tables that I have joined in the design view. The 3 tables all have different information except for invoice number, which is common to all 3. I would like the query to provide me with all the invoice numbers on Table 1 that are not in Table 2 nor in Table 3. In essence, the invoice numbers on Table 1 that are unique to Table 1. I probably will pull some other information in, but I would like the result to be a list of invoice numbers that are in Table 1 and not in the other Tables 2.
Since I am new to Access and still trying to learn, I am having great difficulty in doing this. I suspect it is probably somewhat easy to do. I am using the design view, since that is all I am familiar with right now.
Any help anyone can provide would be greatly appreciated.
Thanks.
Since I am new to Access and still trying to learn, I am having great difficulty in doing this. I suspect it is probably somewhat easy to do. I am using the design view, since that is all I am familiar with right now.
Any help anyone can provide would be greatly appreciated.
Thanks.