Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DLOOKUP fault (2003 sp1 )

    I have a Dlookup which looks like this....

    =DLookUp("so","ZZ5","[sodocid] = [X1]" And " [Pername] = [Name]")


    <font color=red>[So]</font color=red> is a Yes/No value. in a Query <font color=blue>ZZ5</font color=blue>

    <font color=red>[Sodocid]</font color=red> is text string, name of a document eg: "XY-001/hh/001.f9"

    <font color=red>[X1]</font color=red> points to a text field on the report, where Another Dlookup occurs, looking up a similar string 'XY-001/bb/005.g6" from a table

    <font color=red>[Pername]</font color=red> is the name of a person in the <font color=blue>ZZ5</font color=blue> query

    <font color=red>[Name]</font color=red> is a field in a Query <font color=blue>'All people' </font color=blue> that returns the list of names that i'm specifically looking for. (So the report has a source of this query)

    My problem, at the moment, is that its returning positive in all cases. (ie: -1)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DLOOKUP fault (2003 sp1 )

    Does this do what you want?

    =DLookUp("so","ZZ5","[sodocid] = " & Chr(34) & [X1] & Chr(34) & " And [Pername] = " & Chr(34) & [Name] & Chr(34))

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •