dlookup with 3 criteria



Here is my expression:

=IIf(DLookUp("[cmps 28d]","[Laxatives]","[Client ID]=""" & [Client ID] & """
And [Ass #]=" & [Ass #] & " And [Assessment date]=" & [Assessment date])=True,
DLookUp("[28d d/w]","[Laxatives]","[Client ID]=""" & [Client ID] & """ And
[Ass #]=" & [Ass #] & " And [Assessment date]=" & [Assessment date]),0)

Client ID is text
Ass # (shor for assessment number) is number
Assessment date is date

My data is not being shown. It just says 0, when it should be 7

Can anyone see where the problem lies?

--
Message posted via http://www.accessmonster.com

.