Goutam Pal

Goutam Pal

  • NA
  • 13
  • 3.1k

This Is Access Query: Want Sql Query:

May 19 2015 4:52 AM
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: