Thanks Tsumrall. Your solution was what I needed to identify claims that did NOT fall within SOME coverage, but that member might have other coverage for that claim. Say I have a member with 3 coverages, 1/1/01 thru 1/31/01, 3/1/01 thru 3/31/01, and 5/1/01 thru 5/31/01. A claim from 5/11/01...
I have a Claims table with unique MembNo's and ClaimNo's and ClaimDates. I link this to a Member table with coresponding MembNo's. Members might have multiple coverage dates in the Member table, with fields for BegCovDate and EndCovDate, and a single record for each coverage. I need to find if a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.