dlookup

W

Wim

Hi all,

I want to create a dlookup function in which I have to
control a date for two possibilities :

(1) Date can be NULL, so "isnull([EndDate])"

(this works fine)

or

(2) ExamDate can be greater than [Ref_Table]![BeginDate]
and lesser than [Ref_Table]![EndDate]

(this does not work)

How can I solve it ?

dlookup("[Field1]"; "[Table1]"; "isnull([Ref_Table]!
[EndDate] or ([ExamDate] >= #" & [Ref_Table]![BeginDate]
& "# and [ExamDate] <= #" & [Ref_Table]![EndDate] & "#")

???

Thanks,

Wim
 
J

John Spencer (MVP)

PERHAPS the following MIGHT work

DLookup("[Field1]"; "[Table1]";
"IsNull(" & [Ref_Table]![EndDate] &
") OR ([ExamDate] >= #" & [Ref_Table]![BeginDate] &
"# and [ExamDate] <= #" & [Ref_Table]![EndDate] & "#)")
 
Top