Correlating data

  • 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.
 
Antonio,

In your Access database, you would need a little lookup table which
lists the CPT codes and their corresponding CDM codes. Then, you will
need to make a Query which includes both the table that your Excel
data is being imported into, and this lookup table, with a join from
Field17 to CPT, and then you can put all the fields you want on the
report into the query, including the CDM. THis query becomes the
RecordSource for the report.

- Steve Schapel, Microsoft Access MVP
 
Back
Top