dlookup syntax

lesliesoup

New member
Local time
Yesterday, 22:45
Joined
Oct 17, 2013
Messages
4
I am going crazy trying to find what is wrong with this dlookup statement. I am sure it's a stupid quote somewhere. My eyes are no longer focusing trying to find it . Any help would be greatly appreciated


Code:
=DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & Me.Patient_StudyNum_
        & " AND [Assessment_Type]= " 'Inital' ")
 
Hello,
May be like there ?
Code:
[FONT=Arial][SIZE=2]
' If Me.Patient_StudyNum is numeric
axe = DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]=" & Me.Patient_StudyNum _
        & " AND [Assessment_Type]='Inital' ")
' If Me.Patient_StudyNum is text
axe = DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & Me.Patient_StudyNum _
        & "' AND [Assessment_Type]='Inital' ")
[/SIZE][/FONT]
 
Hello lesliesoup, Welcome to AWF :)

Try this..
Code:
= DLookup("[Patient_Weight]", "Frailty_Assessment", "[Patient_StudyNum]='" & _
          Me.Patient_StudyNum & "' AND [Assessment_Type]= 'Inital'")
 

Users who are viewing this thread

Back
Top Bottom