|
There are isolated problems with current patches, but they are well-known and documented on this site. |
I have an excel sheet that contains patient information. Such as
patient ID, First, Last, test score
A patient could have more than one record because of various test. I want to merge all the records for that particular patient and make one record.
So, I would have HDL score, LDL score, CBC score…etc.
How can I do this?
I presume you want to create that single record for the patient in Access. If so, link to the Excel worksheet, and then using that as your data source, run a series of update queries, one for each score, that take the selected score and update that data in the Access record. Of course step 1 is to create the record in Access to begin with. And there needs to be some sort of unique identifier that you can join on to get the right data linked to the right Access record. What you are doing is essentially denormalizing the data to get a single record. Is it possible that a patient might have two or more of the same test records in the Excel worksheet? If so, that may complicate things – my wife has been having blood tests every 4 hours for that past several days…. 
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
