Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dfkehn

    Many-to-many query looking for aggregate condition

    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...
  2. dfkehn

    Many-to-many query looking for aggregate condition

    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...

Part and Inventory Search

Back
Top