oRepVars = NEWOBJECT("Empty") ADDPROPERTY(oRepVars, "iVolOthHrs") SUM curTemp.TOTAL TO oRepVars.iVolOthHrs ...>Just wondering if there isn't a safer/more elegant way to do this, now that we're all the way up to VFP 9...
>PUBLIC iVolSvcCount, iVolSvcHrs, iVolOthCount, iVolOthHrs, iVolCountTotal >PUBLIC iVolActivity, iVolBoard, iVolFundraising, iVolLPPrep, iVolOffice, iVolOther >PUBLIC iVolOutReach, iVolPlanning, iVolTraining, iVolTravel >PUBLIC iVolCtActivity, iVolCtBoard, iVolCtFundraising, iVolCtLPPrep, iVolCtOffice, iVolCtOther >PUBLIC iVolCtOutReach, iVolCtPlanning, iVolCtTraining, iVolCtTravel >PUBLIC iVolWash, iVolOrange, iVolLamoille >>
>SELECT voltime.person_id,SUM(voltime.HOURS)AS TOTAL FROM voltime,curVol; > WHERE voltime.person_id=curVol.person_id; > AND (voltime.DATE BETWEEN THISFORM.txtStartDate.dvalue AND THISFORM.txtEndDate.dvalue); > AND voltime.person_id NOT IN (SELECT person.person_id FROM person WHERE staff); > GROUP BY voltime.person_id; > INTO CURSOR curTemp > >SUM curTemp.TOTAL TO iVolOthHrs >>