G
Guest
I have 25,000+ lines of sanitized medical claims data in an excel file. I
have imported into an access table, and can do a lot of what I need, but not
all.
Many mbr ID’s (bogus, for security) have many, many claims, but with
different claim numbers, dates, etc. Each claim has a mbr id, a claim nbr, a
diagnosis, a date paid, and an amount paid. All this is in a single line
(record) but again, a sick member could have 30 - 40 lines associated with
the mbr id.
I would like to end up with a line which showed member ID, Total Paid, Last
Paid Date, and then below, (or beside) the top 5 highest paid claims for that
member with associated diagnosis and dates paid.
I thought the TOP function would help, but that seems to work at the record
level, not group (mbr id) level. I have also tried queries and sub-queries
and a lot of relational tables stemming from the main table. Would
appreciate any ideas.
Talkin 70, shootin 90
have imported into an access table, and can do a lot of what I need, but not
all.
Many mbr ID’s (bogus, for security) have many, many claims, but with
different claim numbers, dates, etc. Each claim has a mbr id, a claim nbr, a
diagnosis, a date paid, and an amount paid. All this is in a single line
(record) but again, a sick member could have 30 - 40 lines associated with
the mbr id.
I would like to end up with a line which showed member ID, Total Paid, Last
Paid Date, and then below, (or beside) the top 5 highest paid claims for that
member with associated diagnosis and dates paid.
I thought the TOP function would help, but that seems to work at the record
level, not group (mbr id) level. I have also tried queries and sub-queries
and a lot of relational tables stemming from the main table. Would
appreciate any ideas.
Talkin 70, shootin 90