1 2 3 4
|
SELECT F_INVOICING_STATUS.N°, F_INVOICING_STATUS.ID_PROJECT, F_INVOICING_STATUS.[SOURCE DATE], F_INVOICING_STATUS.CUT_OFF_DATE, F_INVOICING_STATUS.[FORECAST REVENUES (TOTAL PROJECT LIFE)], F_INVOICING_STATUS.MONTHLY_INVOICING_PLANNED, DSum("MONTHLY_INVOICING_PLANNED","F_INVOICING_STATUS","N° <=" & [N°] & " AND [ID_PROJECT] = " & [ID_PROJECT]) AS CUMUL_INVOICING_PLAN, F_INVOICING_STATUS.MONTHLY_INVOICED, DSum("MONTHLY_INVOICED","F_INVOICING_STATUS","N° <=" & [N°] & " AND [ID_PROJECT] = " & [ID_PROJECT]) AS CUMUL_INVOICED, [CUMUL_INVOICING_PLAN]/[FORECAST REVENUES (TOTAL PROJECT LIFE)] AS [INVOICING PLAN %], [CUMUL_INVOICED]/[FORECAST REVENUES (TOTAL PROJECT LIFE)] AS [ACTUAL INVOICED %]
FROM F_INVOICING_STATUS
WHERE (((F_INVOICING_STATUS.ID_PROJECT)=Fgv_ID_Project())); |
Partager