Correlating Data Fields

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

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.
 
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.
 
Back
Top