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

.



Relevant Pages

  • Re: Pentesting tool - Commercial
    ... For the assessment work I've done in the past two years on ... Comparing GFI LANguard Network Security Scanner 8 to Qualys ... How does the client acquire new software? ... vulnerability research businesses, and "security" consulting companies ...
    (Pen-Test)
  • Re: Access complains of duplicate key
    ... one-to-many referential integery, and set the field indexed, no duplicates? ... There really is only one assessment per client. ... with the same primary key value in each table. ...
    (microsoft.public.access.formscoding)
  • Re: Access complains of duplicate key
    ... I think perhaps long ago when we began designing this database there were ... There really is only one assessment per client. ... The main data entry form has lots of tabs; the first two tabs look at data ...
    (microsoft.public.access.formscoding)
  • AW: Pentesting tool - Commercial
    ... better savings for the client because a two-week assessment is a large ... How does the client acquire new software? ... Sitz der Gesellschaft / registered office: ... Vorstand / Management Board: ...
    (Pen-Test)
  • Re: Access complains of duplicate key
    ... Call them Client and Assessment. ... The main data entry form has lots of tabs; the first two tabs look at data ... with the same primary key value in each table. ...
    (microsoft.public.access.formscoding)