If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing color or adding a value based on a field value
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 |
Thread Tools | |
Display Modes | |
|
|