Hello,
Thnks in advance for your assistance. I have attached a sample database with a table containing a sample of the data I want to manipulate.
I have data in a table that reports details for each line of a claim as a seperate line. I need to bring the Diagnosis code for each claim line in as a seperate column instead of a seperate row in the table of origin. I want to group this with the claim number.
I tried to create a crosstab query using the claim # as the Row Heading and Diagnosis as the Column Heading with the Repriced amount as the value. I get an error "Too many crosstab column headers (4014)".
There are over 99,000 rows in the original table and some of the diagnosis codes are duplicated, but there are at max 18 diagnosis codes per claim number.
The result I am looking for would be:
Claim # Diag1, Diag2,...etc Sum of Repriced amount.
This is an Access 97 format running on NT OS
Any Ideas?
Donna
Thnks in advance for your assistance. I have attached a sample database with a table containing a sample of the data I want to manipulate.
I have data in a table that reports details for each line of a claim as a seperate line. I need to bring the Diagnosis code for each claim line in as a seperate column instead of a seperate row in the table of origin. I want to group this with the claim number.
I tried to create a crosstab query using the claim # as the Row Heading and Diagnosis as the Column Heading with the Repriced amount as the value. I get an error "Too many crosstab column headers (4014)".
There are over 99,000 rows in the original table and some of the diagnosis codes are duplicated, but there are at max 18 diagnosis codes per claim number.
The result I am looking for would be:
Claim # Diag1, Diag2,...etc Sum of Repriced amount.
This is an Access 97 format running on NT OS
Any Ideas?
Donna
