In a form I have code in the click section it make computations on a dbf called swork.dbf.
THREE="CTOD(DATE_CLOSED)- CTOD(DATE_REC_J)"
DATEGOOD3="CTOD(DATE_CLOSE)>=MSTART .AND. CTOD(DATE_CLOSE) <=MEND .AND. STATUS <> 'CA' .AND. (DATE_CLOSE)<> 'NA'"
BPA="(BPA_NBR <> 'NA' .OR. REMARKS = 'BPA')"
When it gets to this line:
AVER &THREE FOR &DATEGOOD3 .AND. &BPA TO AVGBPA3
It says "Variable 'DATE_CLOSED' not found" when in fact I hit suspend and verify manually and it's ok!
:(
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."