DLookUp Problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tempy
    #1

    DLookUp Problem

    Hi all,
    i am using the DLookUp below to get Total "Project Parts" from a table
    "tblQSPTota ls". I do not get an error but also do not get the value of
    "31" for this person. I have put the Dlookup in the Control Source for a
    text box. The text box is just blank, can somebody please help ?

    =DLookUp("[Project Parts]","tblQSPTotals ","[QSPName] = BEZUIDENHOUT")

    Tempy

    *** Sent via Developersdex http://www.developersdex.com ***
    Tags: None
    • LeighP
      #2
      Re: DLookUp Problem

      perhaps try something more like

      =DLookUp("Proje ct Parts","tblQSPT otals","QSPName = ""BEZUIDENHOUT" "")

      hth

      "Tempy" <anonymous@devd ex.com> wrote in message
      news:avZoe.12$c e4.338@news.usw est.net...[color=blue]
      > Hi all,
      > i am using the DLookUp below to get Total "Project Parts" from a table
      > "tblQSPTota ls". I do not get an error but also do not get the value of
      > "31" for this person. I have put the Dlookup in the Control Source for a
      > text box. The text box is just blank, can somebody please help ?
      >
      > =DLookUp("[Project Parts]","tblQSPTotals ","[QSPName] = BEZUIDENHOUT")
      >
      > Tempy
      >
      > *** Sent via Developersdex http://www.developersdex.com ***[/color]


        Comment

        • Tempy
          #3
          Re: DLookUp Problem

          Thanks very much, this works 100%. All my literature & even help do not
          show 3 but only 2 Apostrophies ?.

          Tempy

          *** Sent via Developersdex http://www.developersdex.com ***

            Comment

            Previous template Next
            Working...