Query if older than... Dateadd issue

charliemopps

Registered User.
Local time
Today, 01:28
Joined
Feb 24, 2009
Messages
40
So I have one field that is "Next callback in" which will be set to how often we need to make a call. 1, 2, 3 hours... etc...
I have a table where every time someone makes a call, they make a timestamp.

Now, I have a query that combines this info.
I want the record to show up, when the last time stamp is older than whatever the "Next callback in" is set to.

I created a query that finds the "Max" in the times stamps, which gives me the last time stamp.

Under that, I put this formula:

<DateAdd("h",-[tbl_status]![Next Callback in],Now())

This should show the record if the last timestampt is less than Now() - [Next Callback in]

Next callback in, is set to 1hr. The last time stamp is over 2hrs ago.
It's not showing up.
What's wrong with my formula?

Thanks!
 

Users who are viewing this thread

Back
Top Bottom