<div>
Pasted your code and the strCriteria = section is all red.
</div>


Pasted your code and the strCriteria = section is all red.

<div>
The two answers combined gave it to me. &nbsp;Thanks!
</div>


The two answers combined gave it to me.  Thanks!

<div>
<div class="content wysiwyg-content">
I am trying to use a dcount function with an &quot;OR&quot; statement and I am not having much luck. &nbsp;I am not even sure if or is permissible.<br />
<br />
Here is my statement.<br />
<br />
Me.SessionNumber = Nz(DMax(&quot;SessionNumber&quot;, &quot;tblSessions&quot;, &quot;[VisId]=&quot; &amp;&nbsp;[Forms]![frmVisits00]![frm<wbr />Visits01].<wbr />[Form]![vi<wbr />sid] &amp;&nbsp;&quot; AND [SessionType] = 'Group' OR 'Group-Other'&quot;)) + 1<br />
<br />
For just GROUP it works fine. &nbsp;for GROUP or GROUP-OTHER it then counts across the entire domain instead of just the VisId.<br />
<br />
Thanks
</div>
</div>


I am trying to use a dcount function with an "OR" statement and I am not having much luck.  I am not even sure if or is permissible.

Here is my statement.

Me.SessionNumber = Nz(DMax("SessionNumber", "tblSessions", "[VisId]=" & [Forms]![frmVisits00]![frmVisits01].[Form]![visid] & " AND [SessionType] = 'Group' OR 'Group-Other'")) + 1

For just GROUP it works fine.  for GROUP or GROUP-OTHER it then counts across the entire domain instead of just the VisId.

Thanks

DCount using &quot;OR&quot;

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.

DCount using &quot;OR&quot;

DCount using "OR"