How to find busy days for an object?

[JC via AccessMonster.com]

Hi,

Appreciate whatever help you coul provide on this.

I've got a table with, say, a text field "subjectName" and two date fields
"BusyFrom" and "BusyTO".

How can I find if "subjectName" is already busy next time I want to enter a
record for him that overlaps (even if partially) some dates already existing
(he's obviously busy all days between the two dates)?

Regards,

 

[John Spencer (MVP)]

SELECT SubjectName
FROM TableName
WHERE BusyFrom <= [TheEndTime] And BusyTo >= [TheStartTime]

 

[JC via AccessMonster.com]

John,
your tip put me into the right path to find the solution
Many thanks