Jump to content

MS Access help

boscobel

By boscobel
in Random Thoughts

 Share

Recommended Posts

boscobel

boscobel

Posted
Posted

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!

Link to comment
Share on other sites
boscobel

boscobel

Posted
  • Author
Posted

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.

Link to comment
Share on other sites
boscobel

boscobel

Posted
  • Author
Posted

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing

  • Best Destination Wedding Sponsors



    Facebook Pinterest Google+ Twitter

  • Posts

    • zjonusasd9915
      Newbie

      By zjonusasd9915 · Posted

      twitter logo png file download pdf online [url=https://www.sliviagraed.com/#53608748]viagra for women[/url] instagram download in app store free install
    • Emmma
      Cabo Azul Wedding Cost / Review

      By Emmma · Posted

      Hi everyone! I have been doing lots of research on various wedding venues all around Mexico, my fiance wants a destination wedding and I am happy to have a wedding wherever so long as the vibe is right and guests are happy!  I have been seriously looking at Cabo Azul and was trying to find potential costs for them, but only found a page about their wedding costs from 2010. Does anyone have any updated information on costs / reviews they would like to share of this venue? Or advice in general, anything helps. Thanks so much, happy wedding planning to all!
    • KristinaH
      Wedding venues and wedding planner in Costa Rica

      By KristinaH · Posted

      Hello everyone, I am dreaming of a wedding in Costa Rica and was wondering if I could get any help with venues and wedding planners. I am thinking Tamarindo because a close friend of mine lives there and I've been in town more than a couple of times, she's being helpful but is at a loss when it comes to this subject really so I was wondering if anyone here had recommendations. I am not closed to other town suggestions either, if I happen to find a good place and staff somewhere else. These are the places I have so far, has anyone had any experience with any of them?  Stay In Tamarindo Luxury Villas in Costa Rica Luxury Villas Pinilla Tropical Homes of Costa Rica The Point Luxury Villa Thank you so much for your help!
    • GeorgeLog
      Unsupportive friends - Another venting topic!

      By GeorgeLog · Posted

      Have you ever considered having a wedding inside a bubble? With the current global situation, many couples are looking for unique and creative ways to celebrate their special day while keeping their guests safe. A wedding inside a bubble could provide a whimsical and intimate setting for your ceremony and reception. Imagine saying your vows surrounded by a beautiful bubble filled with twinkling lights and flowers, creating a magical atmosphere for you and your loved ones to enjoy.
    • GeorgeLog
      Priviate Carribean Vacation?

      By GeorgeLog · Posted

      Adult only resort or not? Let's discuss the pros and cons of choosing an adult-only resort for your honeymoon. While some couples may appreciate the peace and quiet that comes with an adults-only environment, others may prefer a more family-friendly atmosphere. What are your thoughts on this? Have you had any experiences at adult-only resorts that you'd like to share? Let's hear your opinions and recommendations!

  • Topics

×
×
  • Create New...