RE: Multiple Dlookup issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


If I understood:

=DLookUp("[LocationZIP]","Locations","[LocationID]=" & [Forms]![Loads]![Stop
Order]![LocationID] & " And [StopNumber]= " & [Forms]![Loads]![Stop
Order]!StopNumber - 1)



"Mike" wrote:

> Hi. Can someone tell me what I am doing wrong in the phrase below? It's
> supposed to find the zip code from a table for the previous stop on that
> load. I'll properly condition the first stop later. I get a blank field in
> the form. This is from the control source in my subform. If I remove the
> last part I get the current zip code. Here's the phrase.
>
> =DLookUp("[LocationZIP]","Locations","[LocationID]=" & [Forms]![Loads]![Stop
> Order]![LocationID] & " And [StopNumber]=-1+ [Forms]![Loads]![Stop
> Order]!StopNumber")
>
> I did -1+... becuase I wasn't sure where to put the quotes around it. Any
> help would be welcome.
>
> Mike
>
>
>
.

Relevant Pages

  • Re: How did they do this?
    ... >I did put the phrase in quotes. ... When performing the search, ... Prev by Date: ...
    (alt.internet.search-engines)
  • Re: Get your Ki shield here! For a limited time only!
    ... You claim that Mike is a liar and you state that he only quoted one ... word from the article you provided, when what he quotes is "we ... Do you know what a phrase is? ...
    (rec.martial-arts)
  • Re: googling for N.O. rape victims
    ... >Maybe Mike knows the difference between googling ... >for the PHRASE "superdome rape victim", ... where I mention googling on phrases in quotes and the results I got, ...
    (alt.true-crime)
  • Re: password derived key
    ... > mike wrote: ... >> to a secret key? ... how to circumvent dictionary attacks? ...
    (sci.crypt)
  • for the love of Mike
    ... Should we dedicate a thread to Mr. Lyle, "for the love of Mike?" ... First consider the oldest citation found so far: ... James Joyce wasn't the first novelist to use the phrase. ...
    (alt.usage.english)