You're not going to be able to make this sort of query updatable unless you're linking on PrimaryKey Fields, plus you are linking 3 tables to each other which is going to make it impossible to have an updatable query. I'm assuming you want to update/add records to your tblTransaction table but be able to put in your StrInmateNo and have it look up information in both the tblInmateInfo and tblContactInfo tables? If so you'll have to to make sure your strInmateNo is the PRIMARY KEY of the tblInmateInfo table and your strContactNo is the PRIMARY KEY of the tblContactInfo table and use this query:
Code:
SELECT tblTransaction.DteTransDate, tblTransaction.StrMailType, tblTransaction.StrProcess, [StrFirstName] & " " & [StrLastName] AS [Inmate Name], tblContactInfo.StrRelationship, [StrFName] & " " & [StrLName] AS [Contact Name], tblTransaction.StrInmateNo, tblTransaction.StrContactNo, tblInmateInfo.strCategory, [strlname] & ", " & [strfname] AS ContactName
FROM (tblTransaction LEFT JOIN tblContactInfo ON tblTransaction.StrContactNo = tblContactInfo.strContactNo) LEFT JOIN tblInmateInfo ON tblTransaction.StrInmateNo = tblInmateInfo.strInmateNo
WHERE (((tblTransaction.DteTransDate) Between [Enter Beginning Date (example mm/dd/yyyy)] And [Enter Ending Date (example mm/dd/yyyy)]) AND ((tblTransaction.StrMailType)="Visit") AND ((tblTransaction.StrProcess)="Out"));