Calling A Record At A Specified Time

[abbaddon223]

Hi,

I have a table of data which is being presented in a basic form. Users are selecting a data and time to contact a record in the data. Each time they select an outcome, the db moves them on to the next record (rinse, wash repeat etc).

What I'm trying to get to is where the user has specified a date and time to call a record (customer) back, how do I get that record to appear as the next one when they click to move on (IE if they had a record to be called back at 11:00, and they click move to next at 11:15, how do I get the system to call the 11:00 record?).

I've but a query in the form that:

[CallbackDate] = Date() or is Null

This stops records that are in the future coming back, but I'm stuck with the time issue.

Any help appreciated!!

 

[Guus2005]

if you want the next record (11:15) based on a specific time (11:00)

select Min(TimeField) from Table1 where TimeField > 11:00

This query will give you the next record (value) where the timefield is greater than 11:00
In this case 11:15.

HTH