a Question about conditions in access

[fedesc]

Hey you all!
i'm not sure that's the right word. but let's say i have a record that i have put in it a time field.
i need access to recognize if it passed more than one hour to turn red in the background.


for example . i have a alarms db. and the time the alarm started if the alarm is still active after one hour i need it to turn red.
so, what's the proper way to do that?!

[Robeen]

Are you talking about showing this in red on a Form or a Report . . .
?

[fedesc]

Hey , i'm talking about a report .
the report is query based that shows only active alarms.
i want those alarms witch are active more than 1 hour to be red. tnx

[Robeen]

You can use Conditional Formatting on that field and put an expression in saying something like:
if the difference between 'Now' and the time in your Field is more than 59 minutes and 59 seconds - turn the back color red.

[fedesc]

Yeah well that's the way i was thinking to! i just don't know what the right syntax for that.
i have atime field as a date/time field and no idea further . . .

[Robeen]

In your Time field - you ONLY have the Time - no Date?
So - it would look like 3:17 PM - or 7:25 AM?

[fedesc]

nope it's only a long time HH:NN:SS

[fedesc]

Anyone? i couldn't solve it yet.

[Robeen]

Is there any chance that the Alarm will still be active the next day?
What if the Alarm goes off at 11:55:00 PM.
At 12:56:00 AM - one hour and one minute later - if you try & make the logic work by subtracting Start time [11:55:00 PM] from current time [12:56:00 AM] - you will get a negative number . . . and your report cell will not turn red.

[fedesc]

yeah well it could stay for the next day as active
even if it's one minute after the hour i need it to turn red until i dis activate the alarm manually and than it disappears from the sub report

[Robeen]

Sorry it took so long.

Try this in your Conditional Formatting dialog Box:
Choose 'Expression is', enter this as the Expression & then select your Background/Foreground Color.

 
DateDiff("h",[StartDate],Format(Now(),"hh:nn:ss"))>0

[StartDate] is the field in which I have the Time [Eg: 08:25:15 AM] when the Alarm went off.

Let me know if this helps!

[fedesc]

Nope , it didn't do jack! :X change the [startdate] to [ atime]- witch is my time field , even tried to change the ">0" to ">1" both of them didn't affect the record in any way!! :\

[Robeen]

This is working in my test DB.
Could you post a copy of your database here so I can look at it?