Re: Dlookup Help

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



On Mon, 4 Feb 2008 11:32:58 -0800 (PST), FSUrules2883@xxxxxxx wrote:

I am using the following DLOOKUP string.

=DLookUp("TXTFIELD","Query3","Query3.CustomerNumber=" &
"[CustomerNumberFromReport]")

I am try to use the Dlookup to use a value that I get in the report
to lookup in a query and return me back some text. The problem that I
am encountering is it is selecting the first record in the query and
not based on the customer number.

You posted this same question yesterday morning and have received the
same replies you have in this thread.
If you don't understand the replies, or you have trouble implementing
it, rather than re-post the same question, stay within the thread and
tell us what you don't understand or what result you get that is
incorrect.
By asking the same question here you have only wasted other peoples
time and effort and since the replies are the same as in the previous
thread, you are no further along than you were before.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.



Relevant Pages

  • Re: Four Report Problems
    ... I changed to the query like I thought I had, ... I just typed the names of the banks in the Lookup tab. ... Field List into the Report. ... Don't use an expression to format a value. ...
    (microsoft.public.access.reports)
  • Re: Access newbie needing Help with Access table lookups
    ... You can normalize your Contacts table with a union query like: ... a report to show this timeline of events. ... Events entry form and tabs off the field, I wanted to do a lookup ...
    (microsoft.public.access.queries)
  • Re: report
    ... Combos on a report are not very useful. ... and add the lookup table to the query. ... > line around my boxes. ...
    (microsoft.public.access.reports)
  • Re: Duane Hookum
    ... Changing them in the table effected the query and I manually changed ... the only problem is in the orginal report as everything else works ... When changing the field from lookup to not lookup it changed to text. ... group/sort, control, etc. ...
    (microsoft.public.access.reports)
  • Re: Jet Database does not recognize Forms........................
    ... no these are just simple queries. ... Common to Lookup - up to say 12,000 records. ... Calls the Result of the Lookup Table as a label for the Report. ... Creates 2 Charts using results of Query 3. ...
    (microsoft.public.access.reports)