Search results for query: *

I need to capture records with the minimum claim ID where provider, diagnosis, and billed amount are the same but claim id and check id are different. EXAMPLE: CLAIM ID DOS PROVIDER DIAGNOSIS BILLED AMOUNT CHECK# 2001 02/05/2011 500 252.5 30.00 35 2015 02/05/2011 500...

Hi, thank you for your quick response. The code works perfect! Thank you very much. rb

Hello, I need to extract the middle initial from a name field that contains the last name, comma, and the middle name or initial. There is no space after the comma and, in some cases, there is a space in the last name. Example data: Smith,Jane Ron Dow,John L Ali Welsh,Mary Jane The result I...

Thank you so very much for your quick and great response! I tried the formula you suggested and it worked. Thanks again. rb

I need to capture patients who have 2 or more coverages and have at least one Managed Care coverage. I grouped by patient and added a summary of patID. In Select Expert-Group Selection, I entered Count({PATIENT.PAT_ID}, {PATIENT.PAT_NAME}) >= 2. I now have a list of patients who have 2 or more...