Hi. I am a fairly new Access user so I am still pretty much in the dark. How can I get the value in a specific cell from a table(Table A) and copy it to a text field in my report(Report 1)?
I have some knowledge of SQL- can I use this in my problem?
(SELECT tblImmunization.dateAdministered
FROM tbl.Immunization
WHERE tblImmunization.PatientID = *value*
AND tblImmunization.Vaccine = *value*; )
For example: Get the administration date given the patient ID and vaccine (all from Table A) and put this date in a particular text field of the immunization certificate (Report 1).
Is there a feature in Access I can use to be able to do this copying or can I only do this with some VB coding? If so, how do I do/code it?
Thank you very much for your patience with me. =)
I have some knowledge of SQL- can I use this in my problem?
(SELECT tblImmunization.dateAdministered
FROM tbl.Immunization
WHERE tblImmunization.PatientID = *value*
AND tblImmunization.Vaccine = *value*; )
For example: Get the administration date given the patient ID and vaccine (all from Table A) and put this date in a particular text field of the immunization certificate (Report 1).
Is there a feature in Access I can use to be able to do this copying or can I only do this with some VB coding? If so, how do I do/code it?
Thank you very much for your patience with me. =)