0
Answer

This Is Access Query: Want Sql Query:

Goutam Pal

Goutam Pal
9y
377
1
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:

Next Recommended Forum