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!
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!