Add a table to your database that has the CPT and the corresponding CDM codes.
tblConvertCPTCDM
CPT
CDM
Now, build a query and link that table to your imported table. I would probably
use an Outer Join just in case you are missing one of the conversions or someone
has entered an invalid CPT on the spreadsheet.
SQL would look SOMETHING Like:
SELECT S.*, T.CDM
FROM Spreadsheet as S LEFT JOIN tblConvertCPTCDM as T
ON S.Field17 = T.CPT
Substitute your field and table names as appropriate.
Antonio wrote:
>
> I have an excel spread sheet that I would like to import
> into Access. This Excel spread sheet contains 25
> individual data fields and between 10 to 20 entries per
> sheet (they are batched by date of scan). All 25 fields
> contain some sort of information. The requirement is to
> have a report print out that displays the uploaded
> information as well as one extra field of data. This field
> of data is related to filed #17 of the original 25 data
> fields. This field is a numeric code called "CPT".
> This "CPT" code has a corresponding "CDM" code that is
> used for billing within the department. My boss would like
> a report that contains all of the origial data plus the
> CDM code that corresponds to the CPT code. This report
> would then in turn be sent to the data entry personnell
> within the department. I am not sure how to design/set up
> the correlation between data field #17 and the
> corresponding CDM code.
|
Similar Threads
