Re: Subform or Query

Tony,
Please provide a few examples of "old" data records setup vs. the "new" records setup.
From your description though... it sounds as though the new setup is more efficient for
importing into a database. Can't say for sure until we see the data.

And... please don't post duplicate individual questions to several newsgroups. This
causes duplication of responses and/or problems following the "flow" of the problem
determination process.
If you must multi-post, put a couple of newsgroup addresses on the same post. That
way, a response in one group will be seen in the other/s...

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions


"Tony S." <TonyS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:29839F4E-CA36-4442-93B2-58958A5666BF@xxxxxxxxxxxxxxxx
I have imported files from an excel spreed*** 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


.