A
Alex Martinez
I have a tracking systems for logging in disputed (Insurance) claims. I
contains two different tables. Data gets uploaded into the database to both
tables. The table consist of the following fields:
Claims - Table
Policy_Number - text (field size 5)
Received - date
Policy_Type - text (field size 2)
AssignedTo - text (field size 10)
FinishedClaims - Table
I have another table that is joined
PolicyNumber - text (field size 5)
Completed - date
Assigned_To - text (field size 10)
What I want is to show all Policies in the Claims table and if there is a
match (PolicyNumber) in the FinishedClaims display the Completed date and
Assigned_To field . I have done this without a problem, but my problem is
if there are two exact same policy in the Claims table I run into problems
having the FinishedClaims PolicyNumber to join properly with the
Policy_Number in the Claims table. For example:
Claims - Table
PolicyNumber Received date Policy_Type AssignedTo
T2315 2/10/2006 AT Tim66
T2315 2/15/2006 GL anna98
Finsihed Claims - Table
Policy_Number Completed Assigned_To
T2315 2/12/2006 Tim66
T2315 2/20/2006 john88
Results I want:
PolicyNumber Received date
Policy_Type AssignedTo Policy_Number Completed
Assigned_To
Result 1 T2315 2/10/2006 AT
Tim66 2/12/2006 T2315 2/12/2006
Tim66
Result 2 T2315 2/15/2006 GL
anna98 2/20/2006 T2315 2/20/2006
john88
The problem I get is that Result 1 will have 2/20/2006 Completed date
instead of 2/12/2006. How can I get the result the way I have above? Any
tips or website to go will be appreciated. Thank you in advance.
contains two different tables. Data gets uploaded into the database to both
tables. The table consist of the following fields:
Claims - Table
Policy_Number - text (field size 5)
Received - date
Policy_Type - text (field size 2)
AssignedTo - text (field size 10)
FinishedClaims - Table
I have another table that is joined
PolicyNumber - text (field size 5)
Completed - date
Assigned_To - text (field size 10)
What I want is to show all Policies in the Claims table and if there is a
match (PolicyNumber) in the FinishedClaims display the Completed date and
Assigned_To field . I have done this without a problem, but my problem is
if there are two exact same policy in the Claims table I run into problems
having the FinishedClaims PolicyNumber to join properly with the
Policy_Number in the Claims table. For example:
Claims - Table
PolicyNumber Received date Policy_Type AssignedTo
T2315 2/10/2006 AT Tim66
T2315 2/15/2006 GL anna98
Finsihed Claims - Table
Policy_Number Completed Assigned_To
T2315 2/12/2006 Tim66
T2315 2/20/2006 john88
Results I want:
PolicyNumber Received date
Policy_Type AssignedTo Policy_Number Completed
Assigned_To
Result 1 T2315 2/10/2006 AT
Tim66 2/12/2006 T2315 2/12/2006
Tim66
Result 2 T2315 2/15/2006 GL
anna98 2/20/2006 T2315 2/20/2006
john88
The problem I get is that Result 1 will have 2/20/2006 Completed date
instead of 2/12/2006. How can I get the result the way I have above? Any
tips or website to go will be appreciated. Thank you in advance.