>>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...