Jump to content
Sign in to follow this  
boscobel

MS Access help

Recommended Posts

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!

Share this post


Link to post
Share on other sites

Ok, so of course AS SOON AS I posted this a lightbulb went off in my head. I was able to figure it out. I created an unmatched query to compare the two tables and give me the data that I needed.

 

Sorry to have bothered!

 

MODS - if anyone cares, this can be deleted, since it was unnecessary.

Share this post


Link to post
Share on other sites

Hehe...glad you figured it out! I was totally in to your problem & was going to suggest creating a query where one of the criteria is NOT = "deduct". Sounds like you've got it :)

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×