>>>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!
>>>
>>>:(
>>
>>Is it date_close or date_closeD?
>
>That's it! you're pretty sharp today. Thing is, I copied that text from another prg I had working perfectly previously and the 'd' must have gotten added inadvertantly. Also what thru me off was that it said variable when it is a field!
>thanks.
If it was a field, it would have to be a table in a DBC, not a free table, because DATE_CLOSED is 11 characters long. Free table field length is limited to 10 characters.