Search results for query: *

Thanks Chris, I will look further into Proc Transpose. Hopefully that will solve my problem.

IDNUM Type Plan Desc StMonth EndMonth 9578 1 AA1 Single Jan-00 Jan-00 9578 1 AA2 Double Jan-00 Jan-00 9578 1 AA3 Triple Jun-00 Jul-00 9578 1 AA4 Quarter Jul-00 Jul-00 9578 2 AA5 Fourth Jan-00...

Hi Jeremy, Thanks for your query. It worked like a charm. However is it possible to add another condition to the IIF statement. Current members have their end date blank. That means that they are still active and eligible for services. For eg, Member ID Effective Date End Date...

Hi Jeremy, Thanks a lot for your input. Will see if the IIf works here. It will save me a lot of time. Thanks again for your answer. JackieFlash

Stew, Thanks a lot for the feedback.Will take your advice to create a separate table for members. Thanks, JAckieFlash

Hi Stew, Thanks for the reply . Appreciate it. However it doesnt work. There are only two tables, (1)Eligibility Table AND (2) Visits table. The Eligibility table has all the member information in it including member ID. Eligibility Table Member ID Effective Date End Date...

This pertains to health insurance data. I have two tables. One contains a members eligibility history (Eligibilty Table) and the other contains their visits to clinics, hospitals, etc ( Visits Table). I need to find a way to find if they are eligible for the visits. The problem I am having is...

This pertains to health insurance data. I have two tables. One contains a members eligibility history (Eligibilty Table) and the other contains their visits to clinics, hospitals, etc ( Visits Table). I need to find a way to find if they are eligible for the visits. The problem I am having is...