MS Access help

I've been trying to write this forever, cuz I am stuck, but it's even hard to explain!

I have an Access db that contains raw data that I need to manipulate in certain ways and to show specific things. This particular job is for insurance. Each insurance job has charges hit and the first $xxx are the deductible. So once the job reaches the deduct amount, we move that to a different work order to submit ONLY the insurance charges that are due to be reimbursed. Each claim has many many lines.

The thing I am having trouble with is creating a query that will show me only claims that don't have %deduct% in the description line. Since there are many lines per claim, it gives me all the other lines, when in reality, I want it to look at the claim more overall instead of line by line.

I thought I fixed this problem by creating a make-table query that gives me every claim that DID have a deduct charged to it. I was then going to create a new table from the table and say give me all claims that AREN'T in this list. I think this is called an exclusionary query...

It makes so much sense in my head, but I can't get it to dang work in the system.

Anyone have any ideas? This needs to be resolved like pronto, otherwise I will have to start manually researching the claims and that's a damn bitch. Oh yeah, cuz the deduct's need to be moved before 4pm tomorrow to make it in the system on time!

Yay! Don'tcha hate when that happens though? It's like I just needed to write it all out and stew on it for a bit and then it made complete sense. The worst part is there were only 3 claims that I needed to make an entry for this month! So hours of work and 3 fricking lines. Oh well, at least I have it figured out for next month now!