nested Dlookup

G

garye

Can I look up information in a table based on 2 fields and return it to
a form. I want to fill in the description of a job, but the job also
has a suffix, which is a seperate feild. Currently I have
this:=DLookUp("[description]","[Qry Open Jobs T&L]","[job] = [Job#]").
The problem is we have jobs with the same job number but different
suffix.
 
D

Douglas J. Steele

=DLookUp("[description]","[Qry Open Jobs T&L]","[job] = [Job#] AND [suffix]
= [Suffix#]")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mouse move property 3
Using DLookup on a query to set value on AfterUpdate 3
How to auto-populate some fields from the last record to the newon 1
Combo box with same table source 5
Multiple Instance of Same code - different filter 9
Multiple Instance of same form retrieving different data. 1
Linking Tables with AutoNumber Primary Keys 1
Linking two tables with autoNumber Primary Keys 4

Top