Query Help Needed

[John]

Hi

I have a table of job ids and dates. What query will get me the job id of
the earliest job after yesterday i.e. a job that is either today, or if
there is no job today, a job that is as soon as possible after today.

Thanks

Regards

 

[Ken Snell [MVP]]

SELECT JobID, JobDate
FROM Jobs
WHERE JobDate =
(SELECT Min(T.JobDate)
FROM Jobs AS T
WHERE T.JobDate>=Date()
AND T.JobID=Jobs.JobID);