Hello
I need a help in sum of some fields
I
I want to sum (p and s and un fileds) id the month is 8 and add in O field?
when i write id the query ,i have a lot of errors
Operation_SUM : IIf ( Month([MONTH)]) ="8",([PLANNED]+[Scheduled]+[Unscheduled]),0)
Could someone help to do this query?
or how can i have a filed of Sum of [PLANNED]+[Scheduled]+[Unscheduled] ??
Thank you
I need a help in sum of some fields
I
I want to sum (p and s and un fileds) id the month is 8 and add in O field?
when i write id the query ,i have a lot of errors
Operation_SUM : IIf ( Month([MONTH)]) ="8",([PLANNED]+[Scheduled]+[Unscheduled]),0)
Could someone help to do this query?
or how can i have a filed of Sum of [PLANNED]+[Scheduled]+[Unscheduled] ??
Thank you