Query, Subform or Macro

[Guest]

I have imported files from an excel spreedsheet into a new database in an
attempt merge some fields. In previous years this data was provided to me
with patient data being on "one" row with certain fields that have different
dates being denoted with the test perfomed and the letter of the month beside
it ex: hgbo for hemoglobin october. This year the contractor split the data
into "three" different rows to accomodate the three different months of tests
instead of the one row with three columns. How can I get this in the form I
need it? Do I create a subform or write a query? There are some 7k records
in this file. please help

 

[John Nurick]

Probably you need to use a linked table to access the new Excel
worksheet, with a query of some kind (maybe a crosstab) to get the new
data into shape for your existing table.

But without a clear description, with examples, of (a) the way the data
appears in the new Excel sheet and (b) the structure of your existing
table(s) one can only guess.

Your description of the "previous years" structure sounds acceptable for
a spreadsheet but unsuitable for serious database work. Maybe you should
seize on this change in the structure of the data you receive as an
opportunity to improve the structure of your database.