<div>
Oh- that explains the value that I've been getting. Instead of using the if statement, if I wanted to write a public funtion that looked at the value of two fields, how would I create the function?
</div>


Oh- that explains the value that I've been getting. Instead of using the if statement, if I wanted to write a public funtion that looked at the value of two fields, how would I create the function?

<div>
Do not accept this as a solution.<br />
<br />
Public Function MyMax(var1, var2)<br />
<br />
MyMax = IIF(var1 &gt;&nbsp;var2, var1, var2)<br />
<br />
End Function<br />
<br />
In your query/report<br />
<br />
=MyMax(hdev, ddev)<br />

</div>


Do not accept this as a solution.

Public Function MyMax(var1, var2)

MyMax = IIF(var1 > var2, var1, var2)

End Function

In your query/report

=MyMax(hdev, ddev)


<div>
<div class="content wysiwyg-content">
Experts, All of the fields following me. are txt fields in my form, based on which the vba runs off of. When I run the code, I get an error message.<br />
<br />
dhrsleft = IIf((DMax(Me.hdev, Me.ddev) - Me.dev) &gt;&nbsp;0, (DMax(Me.hdev, Me.ddev) - Me.dev), 0)<br />
<br />
I am trying to determine the maximum value between hdev &amp;&nbsp;ddev and use that to calculate the variance between that and dev. For example:<br />
if hdev = 10, ddev= 15 and dev= 10 then I want the dhrsleft = max(10,15)-10 = 5<br />
<br />
Please help/
</div>
</div>


Experts, All of the fields following me. are txt fields in my form, based on which the vba runs off of. When I run the code, I get an error message.

dhrsleft = IIf((DMax(Me.hdev, Me.ddev) - Me.dev) > 0, (DMax(Me.hdev, Me.ddev) - Me.dev), 0)

I am trying to determine the maximum value between hdev & ddev and use that to calculate the variance between that and dev. For example:
if hdev = 10, ddev= 15 and dev= 10 then I want the dhrsleft = max(10,15)-10 = 5

Please help/

dmax error

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.