Query for 1 or 0 in one field according to positive or negative numbers in another field

[mfred]

I need to create a query in Microsoft Access to enter 1 or 0 in a field based on whether numbers in another field is positive or negative. Here are the details.

1 entered in a "late" field if "TotalHoursAheadOrBehindScedule" field has a positive number
0 entered in a "late" field if "TotalHoursAheadOrBehindScedule" field has a negative number

This is a bit outside of my query knowledge. Can anyone advise with inforamtion for writing such a field query?

Thanks in advance.

[rpeare]

if this is in a query

Late: iif(totalhoursaheadorbehindschedule >0, 1, iif(totalhoursaheadorbehindschedule <0, 0, 99))

you don't account for totalhoursaheadorbehindschedule being zero in your original post so I'm having it be 99, modify at your discretion.

If it's on a form the controls source of the text box would be:

=iif(totalhoursaheadorbehindschedule >0, 1, iif(totalhoursaheadorbehindschedule <0, 0, 99))

[mfred]

It is a query. Thank you very much for the help.