Prev: IIF function for 3 criteria, possible?
Next: Why Won't Variance & Standard Deviation Work
From: 116 on 7 Apr 2010 10:08
I have 2 tables...Job and Material. I am trying to configure dlookup to
return value of 'Note_Text' in table 'Material' based on 'Part_Number' in
table Job.

DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]")

Any help would be greatly appreciated.

Thanks
David
From: Allen Browne on 7 Apr 2010 10:36
Concatenate the value into the criteria string:
=DLookUp("[Note_Text]","Material","[Material] = " &
Nz([Job]![Part_Number],0))

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"116" <dweekley(a)stdgear.com> wrote in message
news:01C470F1-E42F-457E-94F1-F53D42E53E90(a)microsoft.com...
> I have 2 tables...Job and Material. I am trying to configure dlookup to
> return value of 'Note_Text' in table 'Material' based on 'Part_Number' in
> table Job.
>
> DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]")
>
> Any help would be greatly appreciated.
>
> Thanks
> David

From: RonaldoOneNil on 7 Apr 2010 10:45
Assuming the source for your query is the table Job and Part_Number is a text
field.
Add the Part_Number into your query and then use the following in another
column in your query.

Note Text: DLookUp("[Note_Text]","Material","[Part_Number] = '" &
[Part_Number] & "'")

"116" wrote:

> I have 2 tables...Job and Material. I am trying to configure dlookup to
> return value of 'Note_Text' in table 'Material' based on 'Part_Number' in
> table Job.
>
> DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]")
>
> Any help would be greatly appreciated.
>
> Thanks
> David
From: 116 on 7 Apr 2010 10:54
Thanks for the assist. I see what I was doing wrong.

David

"RonaldoOneNil" wrote:

> Assuming the source for your query is the table Job and Part_Number is a text
> field.
> Add the Part_Number into your query and then use the following in another
> column in your query.
>
> Note Text: DLookUp("[Note_Text]","Material","[Part_Number] = '" &
> [Part_Number] & "'")
>
> "116" wrote:
>
> > I have 2 tables...Job and Material. I am trying to configure dlookup to
> > return value of 'Note_Text' in table 'Material' based on 'Part_Number' in
> > table Job.
> >
> > DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]")
> >
> > Any help would be greatly appreciated.
> >
> > Thanks
> > David
From: 116 on 7 Apr 2010 13:08
Trying to apply this 'MID([MemoField]
,Instr(1,[MemoField],"StartTag")+ Len("StartTag")
,Instr(1+Instr(1,[MemoField],"StartTag"),[MemoField],"EndTag")
-Instr(1,[MemoField],"StartTag") - Len("StartTag"))' to the 'dlookup' with
no success. I can however add another column in the query and get it to
work. I am using this info in a report, yet not in access.

David

"116" wrote:

> Thanks for the assist. I see what I was doing wrong.
>
> David
>
> "RonaldoOneNil" wrote:
>
> > Assuming the source for your query is the table Job and Part_Number is a text
> > field.
> > Add the Part_Number into your query and then use the following in another
> > column in your query.
> >
> > Note Text: DLookUp("[Note_Text]","Material","[Part_Number] = '" &
> > [Part_Number] & "'")
> >
> > "116" wrote:
> >
> > > I have 2 tables...Job and Material. I am trying to configure dlookup to
> > > return value of 'Note_Text' in table 'Material' based on 'Part_Number' in
> > > table Job.
> > >
> > > DLookUp("[Note_Text]","Material","[Material] = [Job]![Part_Number]")
> > >
> > > Any help would be greatly appreciated.
> > >
> > > Thanks
> > > David
 | 
Pages: 1
Prev: IIF function for 3 criteria, possible?
Next: Why Won't Variance & Standard Deviation Work