Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
SELECT A.AssignmentID, R.Rate FROM (tblMalpracticeLocations L INNER JOIN tblAssignments A ON L.LocationID = A.MPLocation) INNER JOIN tblMalpracticeRates R ON (L.TerritoryID = R.TerritoryID) AND (A.MPSpecialty = R.SpecialtyClassID) ORDER BY A.AssignmentID;
DLookup("Rate", "tblMalpracticeRates", "(SpecialtyClassID = " & Forms![frmAssignments]!MPSpecialty) AND (TerritoryID = DLookup("TerritoryID", "tblMalpracticeLocations", "LocationID = & Forms![frmAssignments]!MPLocation")))
|database opened as read only||10||32|
|UK Date format in MS Access||4||22|
|How to force the Combo box to refresh when setting its first column (col 0) from another Form.||6||34|