This Is Access Query: Want Sql Query:

Question

This is Access Query:

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] & "'"),

[Cal-DB-CY_Base Load Dashboard]

.[Utilized payroll] = DLookUp("[Base Key- Utilized payroll]",

"[Cal-DB_Utilized payroll summary for loads]"

,"[Base Key]='" & [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'"),

[Cal-DB-CY_Base Load Dashboard]

.[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]",

"[Cal-DB_Utilized payroll summary for loads]"

,"[Base Key]='" & [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'"),4),

[Cal-DB-CY_Base Load Dashboard]

.FTE = DLookUp("[Base Key- Count]","[Cal-DB_Utilized payroll summary for loads]",

"[Base Key]='"

& [Cal-DB-CY_Base Load Dashboard].[Base Key] & "'")

 

 

 

Want to convert Sql Query: