>>>>IF Statement Doesn't Seem to be Working
>>>>
>>>>
>>>>IF Abs.late=0 AND Abs.absent=0 AND Abs.early=0
>>>> MESSAGEBOX('You need to make a non-zero entry') + CHR(13) + ;
>>>> 'in either Late:, Absent:, or Early:', 0+48+0, 'Error')
>>>>
>>>>
>>>>Even if the fields Late, Absent, & Early contain zeros (0.00), this MESSAGEBOX never gets processed, the program just goes right on as if everything is fine.
>>>>
>>>>Need help. TIA, CH.
>>>
>>>How about:
>>>
>>>IF Late + Early + Absent = 0
>>> MESSAGEBOX()
>>>ENDIF
>>>
>>Hey! I like that! :>
>>simple, clean, catches fractions which may display as zero...
>
>No, that doesn´t work!! What if LATE=-1, EARLY=1, ABSENT=0?

TRY IF round(Abs.late)=0 AND round(Abs.absent)=0 AND round(Abs.early)=0