Date Clash Query Help Please

[ebasshead]

Hi everybody,

I have an access database that books houses for people to stay in. I'm trying to build a query which will find clashes in booking dates, ie it will compare arrival and departure dates of houses and if there is an overlap of dates, those houses with booking clashes will be listed. I'm trying to write an iif statement to compare dates but I can't get my head around how to go about it. Any help would be massively appreciated cos I accidentally discovered one booking clash and now I'm worried there may be others.

My table where the info is being pulled from is tblRRCustomers, the fields are
Property
ArriveDate
DepartDate
IDCustomers

Thank you for your thoughts

Eddie

[FishVal]

Hi, Eddie.

There are several threads in the forum dealing with the same.
For starters you may check the following.
How to prevent overlapping schedules?
How to prevent the overlapse range entry ?
Iif query

Regards,
Fish

[ebasshead]

Thanks for the pointers Fish, I adapted the Hair Salon and it works great.
Cheers Eddie

[FishVal]

You are quite welcome.

Best regards,
Fish.