S
Secret Squirrel
I'm trying to update a field in my tblEmployees but it needs to update only
the records where the ID in the qrywagetype is the same as the ID in the
tblEmployees and those records in the qrywagetype equal "salary". I'm getting
the error that it's not an updateable query. Where am I going wrong?
UPDATE tblEmployees INNER JOIN qryWageType ON tblEmployees.ID =
qryWageType.ID SET tblEmployees.PTimePaid = True
WHERE (((qryWageType.WageType)="Salary"));
the records where the ID in the qrywagetype is the same as the ID in the
tblEmployees and those records in the qrywagetype equal "salary". I'm getting
the error that it's not an updateable query. Where am I going wrong?
UPDATE tblEmployees INNER JOIN qryWageType ON tblEmployees.ID =
qryWageType.ID SET tblEmployees.PTimePaid = True
WHERE (((qryWageType.WageType)="Salary"));