February 27th, 2009, 11:08 AM
How to add a record ID to a access table
I have a table in access that has only two fields: one is the PATIENT_ID and the second is DRUG_NAME. There are multiple records with different DRUG NAMES for each patient ID. I am trying to figure out a way to add a third field that would say DRUG_1, DRUG_2, etc for each patient ID. So, the DRUG_1 would start new when it's a new PATIENT_ID
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.