MS Access help
Posted 24 September 2008 - 02:05 PM
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!
Posted 24 September 2008 - 02:18 PM
Sorry to have bothered!
MODS - if anyone cares, this can be deleted, since it was unnecessary.
Posted 24 September 2008 - 04:00 PM
Posted 24 September 2008 - 04:18 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users