i am assuming that each CPT code has only one
corresponding CDM code, and that you know what all the
matches are. if so, create a table in your db with two
fields:
tblMatchCDM
MatchCDM
MatchCPT
add the tblMatchCDM table to the report's underlying
query, with a LEFT JOIN link between the data table's CPT
field and MatchCPT. add field MatchCDM to the Select
statement. now the correct CDM code for every record is
available to the report.
>-----Original Message-----
>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
