Hello all,
I wil try to explain this as best as I can. I need to show the different results in a field (HCPCS) as 1 record instead of multiple records without duplications. Here is example of the query returning single records with the criteria based on the HCPCS Type field:
Procedure Desc Dept Rev HCPCS HCPCS Type
255052127 CATH 3600 636 A4645 CPT.MDCR
255052127 CATH 3600 636 A4645 CPT-4
255052127 CATH 3600 636 A9525 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR
255052127 CATH 3600 636 Q9949 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR
255052127 CATH 3600 636 Q9967 CPT-4
I separated the criteria and created 2 querys (one for each criteria) and created a query from those 2 and got the following:
Procedure Des Dept Rev HCPC(MDC)Type(MDC)HCPC(CPT)Type(CPT)
255052127 CATH 3600 636 Q9967 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR Q9967 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR Q9967 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR Q9967 CPT-4
Obviously I'm getting duplicates that are not needed in the rows. Is there a better way to do this or a way to show the unnecessary field blank where there is no matching HCPCS code and type (such as A9525)? Thanks in advance for your assistance!
I wil try to explain this as best as I can. I need to show the different results in a field (HCPCS) as 1 record instead of multiple records without duplications. Here is example of the query returning single records with the criteria based on the HCPCS Type field:
Procedure Desc Dept Rev HCPCS HCPCS Type
255052127 CATH 3600 636 A4645 CPT.MDCR
255052127 CATH 3600 636 A4645 CPT-4
255052127 CATH 3600 636 A9525 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR
255052127 CATH 3600 636 Q9949 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR
255052127 CATH 3600 636 Q9967 CPT-4
I separated the criteria and created 2 querys (one for each criteria) and created a query from those 2 and got the following:
Procedure Des Dept Rev HCPC(MDC)Type(MDC)HCPC(CPT)Type(CPT)
255052127 CATH 3600 636 Q9967 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR A4645 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR A9525 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR Q9949 CPT-4
255052127 CATH 3600 636 Q9967 CPT.MDCR Q9967 CPT-4
255052127 CATH 3600 636 Q9949 CPT.MDCR Q9967 CPT-4
255052127 CATH 3600 636 A4645 CPT.MDCR Q9967 CPT-4
Obviously I'm getting duplicates that are not needed in the rows. Is there a better way to do this or a way to show the unnecessary field blank where there is no matching HCPCS code and type (such as A9525)? Thanks in advance for your assistance!
