UPDATE
[Cal-DB-CY_Base Load Dashboard]
SET
[Cal-DB-CY_Base Load Dashboard].[Load amout] = DLookUp("[Base Key- Load cost]",
"[Cal-DB_Load cost summary table]"
,"[Base Key]='" & [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'"),
.[Utilized payroll] = DLookUp("[Base Key- Utilized payroll]",
"[Cal-DB_Utilized payroll summary for loads]"
.[Load%] = Round(DLookUp("[Base Key- Load cost]","[Cal-DB_Load cost summary table]",
"[Base Key]='"
& [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'")/DLookUp("[Base Key- Utilized payroll]",
,"[Base Key]='" & [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'"),4),
.FTE = DLookUp("[Base Key- Count]","[Cal-DB_Utilized payroll summary for loads]",