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")))
|Error in Rs.MoveNext & Duplication of Record||14||26|
|Access importing CSV that has commas in currency and needs 2 cols formated for numbers to text||5||35|
|How to make query not show results in table form go straight to report||4||21|
|format date field on certain entries||8||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!