<div>
Thank you very much Crystal! That worked perfectly! I get confused with all the double quotes and single quotes. :)
</div>


Thank you very much Crystal! That worked perfectly! I get confused with all the double quotes and single quotes. :)

<div>
you're welcome - happy to help ;)<br />
<br />
if you are using double quotes to specify the criteria, then you can use single quotes inside that to delimit a text value UNLESS the text might have ' ... in which case, substitute &quot;&quot;&nbsp;(2 double quote marks) for each of the single quote marks ~
</div>


you're welcome - happy to help ;)

if you are using double quotes to specify the criteria, then you can use single quotes inside that to delimit a text value UNLESS the text might have ' ... in which case, substitute "" (2 double quote marks) for each of the single quote marks ~

<div>
<div class="content wysiwyg-content">
I am trying to use a DLookup with multiple criteria's but it's not working correctly. Can anyone take a look and see where I went wrong with the criteria's? I am trying to &nbsp;match up the Employee's Name and a date field. <br />
<br />
<br />

<pre><code id="code-10-28970572-1">=DLookUp(&quot;[Wage]&quot;,&quot;qryWageLastMax&quot;,&quot;[EmpName]= &quot; &amp; Nz([cboEmpName],0) And &quot;[WageDate]&lt; &quot; &amp; [txtWageDate])</code></pre>
</div>
</div>


I am trying to use a DLookup with multiple criteria's but it's not working correctly. Can anyone take a look and see where I went wrong with the criteria's? I am trying to  match up the Employee's Name and a date field. 


(CODE)

DLookup Question

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.