adding weekly totals

[former_member1107312]

Hello,

Looking for some assistance here once again

I need to add totals for weekly totals here.  They need to between week 10 and week 14.

Here is what I have, but it an error when I check it, it's highlighting from the else if statement to the end, saying the remaining text does not appear to be part of the formula:

Numbervar Total;

if isnull ({V_PART_REL_WEEK_DATA.WEEK_REL_QTY_FOR_EA_WEEK}) then

Total:= Total +0;

else if {V_PART_REL_WEEK_DATA.WEEK_CALC_DATE} IN DateAdd('ww',10,Minimum(WeekToDateFromSun))TO DateAdd('ww',14,Minimum(WeekToDateFromsun)) THEN

Total:= Total + {V_PART_REL_WEEK_DATA.WEEK_REL_QTY_FOR_EA_WEEK};

Any help will be appreciated.

Thank you,
Gerald

[DellSC · Accepted solution]

Take the semi-colon off the end of the statement before "else".  So "Total:= Total +0;" will become "Total:= Total +0".

-Dell

[former_member1107312 · Accepted solution]

surprising how something so small can cause something so big.

Thanks!