DMin Question (1 Viewer)

[hascons]

Does anyone know if you can use 2 Parameters in a Dmin Function.

For Example:

Public Function ClosestToTiebreakerPoints(WeekNum As Integer, MostWins As Integer) As Double

ClosestToTiebreakerPoints = DMin("TieBreakerPoints", "WeeklyCountWins", ("Week =" & WeekNum & ")And("NumberWins =" & MostWins & ""))

End Function

I Put Parenthesis around the Parameter portion for ease of reading.

hascons

 

[hascons]

I Did Figure this out.
I had an extra ( " ) in front of the second parameter (NumberWins, in this case)