Search results

I don't have tables that relate to the relationship and termination codes. I will check again to make sure. I did explain what the relationship codes meant in a previous post. I will do the same for termination codes. I will upload a sample of the data in an excel sheet tonight.

Tier definitions: Participant - Member only Participant Spouse - Member with Spouse Participant Children - Member with Child(ren) Participant Spouse and Child(ren) - Member with Spouse and Child(ren) I attached a sample of the database to this post. ActMbr.prt_ss_nbr with SSN# 111111111 should...

Thanks for being so patient with me plog, I'll have that info for you shortly. I just need to replace the real SSN's with fake ones. I will also try provide the database table definitions for ActMbr and dependents and in words not code explain each sample row in ActMbrs should fall into based...

I updated my previous Post. Check it out I posted it Today 03:00 PM. I think I got everything you requested. If I missed something let me know.

Here is my new issue. should I create a new POST of continue with this thread? I call this query Pariticipants and Spouse only: I need to get a count of Pariticipants who meet the following criteria: Pariticipants must have an Eligible spouse. Pariticipants can have children but none of the...

I will try this and let you know if it works.

I created a query that gave me the participants who meet all criteria (i.e. Member Group #205, Member Job code is not 'Admin', etc) I called it [PART = Active Members].

I was able to get the below query to do what I wanted but now I have a new dilemma. SELECT ActMbr.prt_ss_nbr, Spouse.dep_depend_ssn, ActMbr.prt_last_dep_nbr, Spouse.dep_seq_nbr, Spouse.dep_relation, ActMbr.ps_cov_type, Spouse.dep_term_date, Spouse.dep_term_flag FROM [PART = Active...

I Should have started this post asking for this: I have a Table called Dependents and a field called Relationship. The Relationship field has the following codes: A=adopted child(ren) F=foster child(ren) D=daughter(s) G=grandchild(ren) X=stepchild(ren) S=son(s) H=Husband W=Wife I have...

Working on the suggestion you provided I'll let you know if it work for me. Thanks

Your right I should have not categorized husband and wife as dependent in my original post. I'm so used to doing that because the husband and wife records are found in the dbo.depfile table AKA the dependent table. Thanks for pointing that out it will help me if I ever have to explain this...

I apologize for the misinderstanding on my part. The query you see in my original post is written to get a count for Employee and Spouse tier only. I am writing 4 separate queries one for each tier. As for the dependent relationship code A=adopted child(ren), F=foster child(ren), D=daughter...

I'm working on a query the will produce counts for 4 different Tiers. Here is the following 4 Tiers. Employee (Member with no Child(ren) or Spouse): Member Status is Active, Member Group# is 205, Member Job Code is not an Admin, Health Coverage Type is Individual...

Greetings, I am new to Access. I started with Access 2003 and upgraded to Access 2007. I've seen many posts from this forum by using Google. It would be better to ask my own questions than try to get answers to my problems from other related questions. I'm impressed with the intelligent and...