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.