I would like to pass information to a query via a function in access.
Public Function fnGetClinicFromSwitch() As Variant
Dim intStatus As Variant
intStatus = fnGetClinicAllStatus()
If intStatus = -1 Then
fnGetClinicFromSwitch = ">0"
fnGetClinicFromSwitch = Forms!frmReports.lstSelectClinic
I would like to place this function in the criteria of a query to return the ">0" as the query's criteria. It is not working. I.e. intStatus = -1..