DLookup

[NT100]

Hi,

I'm working on DLookup with 3 criteria in the following scripts

Dim iRoatation, iSession as integer;

iRoataton = 1
iSession = 1


DLookup("[Session]","tblTAssign_FPA","[AcademicYr] = " & txtApptYr.Value & " AND " & [Rotation] = iRotation & " AND " & [Session] = iSession & ")"

However, it is syntax error. Would you have any suggestions?

NT100

 

[Ranman256]

AND [Rotation] =" & iRotation & " AND [Session] =" & iSession & ")"

 

[ashleedawg]

Close!

I think you want:

DLookup("[Session]","tblTAssign_FPA","[AcademicYr] = " & txtApptYr.Value & " AND [Rotation] = " & iRotation & " AND [Session] = " & iSession )

 

[isladogs]

Getting closer ....

If the academic year is a string value e.g. 2016-17, you need text delimiters for that part - added in RED below

DLookup("[Session]","tblTAssign_FPA","[AcademicYr] =[COLOR="Red"] '[/COLOR]" & txtApptYr.Value & "[COLOR="red"]'[/COLOR] AND [Rotation] = " & iRotation & " AND [Session] = " & iSession )

BUT this is looking up the value of the Session field when one of the criteria is that Session is iSession which equals 1

So getting closer still ....

[Session]=1

 

[NT100]

It works. Thanks.

 

[isladogs]

Just out of interest, which one worked?