I am trying to report on login/logouts from a system and have a question.

4 fields that matter:
login_time Unix time the user logged in (ie..1168460873)
logout_time Unix time the user logged out

login_time_text Converted login time (1/10/2007 2:27:53 PM)
logout_time_text Converted logout time

logout_time has the potential to be 0, if someone doesn't logoff but is
disconnected from the system.

I have done 2 queries so far:
1. If the logout_time = 0, then logout_time = 'No Logout'
2. If the logout_time = 0, then logout_time = login_time + 3600 (1 hour)

What I really want to do is if the logout_time = 0, then add i hour to the
login_time and either change the color of the line or put smething like 'No
logout' in a different field that can be added to a report.

Hope this makes sense.
Thanx alot...Paul