Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get Specific Value from a Table and Copy it to a Textfield of a Report

Status
Not open for further replies.

kismet

MIS
Mar 5, 2003
24
PH
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. =)
 
Hi

You could try a Dlookup statement I think that it could solve your problem.
Type Dlookup in your code and press F1 to get the correct syntax.

Rgds Herman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top