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

I just can't figure out the real problem on this thread! There should be some hidden workaround of the entire module because I tried the same approach, same table, same field (name, type, decimal), and it works fine on my computer.

original:

IF abs.late = 0 AND early = 0 AND absent = 0
      MESSAGEBOX(blah...)       
ENDIF

No problem! How about on your pc contributors? Try it and see...